Calculating Time Help

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Floyd Forbes - 20 Nov 2007 22:23 GMT

I have two textboxes with sTime and eTime. If I enter time as decimal how do
I
calculate time.e.g

sTime = 7.00
eTime = 1.00
TotalTime = 6.00

Floyd

Reply to this Message

Allen Browne - 20 Nov 2007 23:09 GMT

See:
Calculated fields
at:
http://allenbrowne.com/casu-14.html

Signature

Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

>I have two textboxes with sTime and eTime. If I enter time as decimal how
>do I
[quoted text clipped - 5 lines]
>
> Floyd

Reply to this Message

John W. Vinson - 21 Nov 2007 05:15 GMT

>I have two textboxes with sTime and eTime. If I enter time as decimal how do
>I
[quoted text clipped - 5 lines]
>
>Floyd

Well... time isn't really decimal. is 1.00 1AM? or 1PM? Is 1.00 later than
11.00 or two hours earlier? Do your times ever span midnight?

If it's decimal numbers... just subtract. 7.00 - 1.00 is in fact 6.00. If
it's actually times of day, consider using a Date/Time field storing the date
and time (so that #11/20/2007 1:00:00# is actually two hours after #11/19/2007
23:00:00#) and using DateDiff() to calculate the time between.

John W. Vinson [MVP]

Reply to this Message