Time Calculation

[Zahid Hussain]

I have a Date/Time field "hh:mm" (Utilization Time) in report and want to sum it up in report footer. Simple "hh:mm" formatting of =sum([Utilization Time]) does not provide correct total of the field, the answer remains under 24:00 (apparently due to time format). My report is based on a query where I have calculated "Utilization Time" between two fields "Start Time" and "End Time" by simply using [End Time]-[Start Time] expression. If I use DateDiff("n",[End Time],[Start Time]), it only provides minutes (or hours etc.).
I would appreciate if somebody can help me!

 

[JeepsR4Mud]

I'm not sure I understand.

I've done somethign similar with dates, but but not time.

I was looking at the age of parents at the birth of their first child. I had the birthdate of the first child and the birthdate of the parent.

I used the date difference, which I think, outputed the data in a numberic format, and was in days. I simply adjusted the formula to divide by 365.25 to arriave at days.

If your query has a field Utilization time, I'm not sure why you couldn't sum it. Or sum it in a separate query.