Military Time

[davidwdf]

I'm subtracting military time.

Start = 0930

End = 1200

Time spent = 270

OK, my question is how can I get the results to show 2hrs and 30min?

thanks

wdf

[RalphL]

You are using numbers as time. Convert the start time to a calculated time field. StartTime =Time(Left(start,2), Right(start,2), 0). Convert the end time to a calculated time field. EndTime =Time(Left(end,2), Right(end,2), 0). Make TimeSpent a calculated time field = EndTime - StartTime.