Sum Time

[miyomo]

Hi,
I' m trying to build a db using access..
I have 2 fields: StartTime, EndTime and I would
retrieve the TotalTime (EndTime - StartTime) with a query
in the "hh.mm" format.
I can I accomplish this?
How can I manage times past midnight?

TIA
miyomo

 

[Steve Schapel]

Miyomo,

Try this...
TotalTime: Format([StartTime]-1-[EndTime],"Short Time")

 

[miyomo]

Try this...
TotalTime: Format([StartTime]-1-[EndTime],"Short Time")

Great!!! It works fine! Thanks.
I have another question if you don't mind
My tables is:

Activities StartTime EndTime TotalTime
******* ******* ******* *******
Swim 0930 1030
Run 1430 1530 0100

I would like to perform the time calculation
only for certain activities (eg. not Swim)
Is that possible?
I would like to have only SQL. I use *only* access file
without MSAccess (I'm using Delphi)

Thanks anyway!
Miyomo

 

[miyomo]

Activities StartTime EndTime TotalTime
******* ******* ******* *******
Swim 0930 1030
Run 1430 1530 0100

I would like to perform the time calculation
only for certain activities (eg. not Swim)
Is that possible?
I would like to have only SQL. I use *only* access file
without MSAccess (I'm using Delphi)

Disregard! I solved in this way:
SELECT Voli.Attivita, Voli.Hi, Voli.Hf, IIf(Voli.Attivita like "Swim*"
,'',Format([HI]-1-[HF],"Short Time")) AS Block
FROM Voli;

Thanks for your help!!

miyomo