Elapsed Time Calcuation with DateDiff

[Gigi0614]

I have a form with

TimeIN (short time)
TimeOUT (short time)

Elapsed Time ---> calculated field that is giving me trouble!!

I thought I could use the DateDiff function:

DateDiff ('h', [TimeIN], [TimeOUT])

But it's not working...

For example if somebody entered the following

TimeIN: 1:15 AM
TimeOUT: 2:00 AM

Elapsed time should equal 00:45

How can I get this to work??

Thanks!

 

[Gigi0614]

Actually...

TimeIN & TimeOUT are defined as Medium Time,

ElapsedTime is defined as Short Time

 

[PHV]

Something like this ?
Format(TimeOUT-TimeIN, "hh:nn")

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[TheAceMan1]

How are ya Gigi0614 . . . . .

Try:

[blue]Format([TimeIn]-1-[TimeOut],"Short Time")[/blue]

See Ya! . . . . . .

 

[Gigi0614]

That got it!! Thank you very much!!

 

[caddy36]

How do you account for times great than 24 hours?

My statement here which works fine for up to 24 hours gives me an error OVER 24 Hours:

time(DateDiff("d",{reservation_request.rr_create_stamp},{reservation_request.rr_completestamp})-(if datepart("n",{reservation_request.rr_create_stamp}) < datepart("n",{reservation_request.rr_completestamp})+1 then 0 else 1),DateDiff("n",{reservation_request.rr_create_stamp},{reservation_request.rr_completestamp}) mod 60,00)

How do I Update to account for times > 24 ?

Thanks

 

[caddy36]

Acutally Statement should read:

time(DateDiff("h",{reservation_request.rr_create_stamp},{reservation_request.rr_completestamp})-(if datepart("n",{reservation_request.rr_create_stamp}) < datepart("n",{reservation_request.rr_completestamp})+1 then 0 else 1),DateDiff("n",{reservation_request.rr_create_stamp},{reservation_request.rr_completestamp}) mod 60,00)



I changed the "d" back to "h"

 

[PHV]

Say that d=rr_completestamp - rr_create_stamp, then how about this ?
24*Int(d)+Format(d,"h") & Format(d,":nn")

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244