Time

  • Thread starter Thread starter Bruce
  • Start date Start date
B

Bruce

I need to add together a list of "time spent" that will exceed 24 hours, I
have "Start Time" ,"Finish Time" & "Time Spent" for each row . How do I
create a formula that will add Time Spent in excess of 24 hours. In Excel I
can use Custom Format [h]:mm. What is the Access equivalent?
Thanks
Bruce
 
I need to add together a list of "time spent" that will exceed 24 hours, I
have "Start Time" ,"Finish Time" & "Time Spent" for each row . How do I
create a formula that will add Time Spent in excess of 24 hours. In Excel I
can use Custom Format [h]:mm. What is the Access equivalent?
Thanks
Bruce
Click to expand...

There is none, unfortunately!

Use DateDiff() to calculate [Time Spent] in minutes:

DateDiff("n", [Start Time], [Finish Time])

in your query; sum this field, and use an expression like

TotalTime: Sum([Time Spent]) \ 60 & Format(Sum([Time Spent]) MOD 60,
":00")

The \ isn't a typo - it's the integer divide operator.
 
Back
Top