Calculate Hours Between Two Dates 1

[dmoran]

I have a form with three fields - [begintime], [endtime],and an unbound [totaltime]. I am trying to use DateDiff to give me a total in hh:nn format but it doesn't seem to recognize the dates. In other words, I'm OK until 23:59 total time. My formatting is 99/99/00" "00:00;0;_

Does anyone have an easy solution?

 

[PHV]

Something like this ?
24*Int([endtime]-[begintime])+Format([endtime]-[begintime],"h") & Format([endtime]-[begintime],":nn:ss")

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

 

[snyperx3]

PHV is a date/time god.

-Pete

 

[dmoran]

synperx3 - I too, am convinced!

PHV - I asked for easy and you came through! Works perfect-Thanks