asked on

Calculate number of hours using two field

I have a form which has two fields. They are "StartTime" and "StopTime".

In the bound table I have a calculated field named "ElapsedTime". I want to have that field populate with [StopTime] - [StartTime] in hours.

If StartTime for example is "4/16/2014 2:53:50 PM"
and
If StopTime for example is "4/16/2014 3:01:05 PM"

then the elapsed hours would be something like .13 right?

Anyway, how can I make the calculated field get the right result? I have it setup as Long Integer, Standard, 2 decimals but it isn't working correctly.

--Steve

Bembi

Long integer values do not have decimals. And as time value are measured in days, an integer can not calculate hours. Hours are calculated as parts of a day, let say 6am is 0,25 and 6pm is 0,75. THe difference is 0,5 means half a day = 12h.
If you use single or double as field type, it should work.

akb

Set the field as General or as a Number if you want to fix decimal points.
Multiply the answer by 24 to get hours.
Or multiply the answer by 1440 to get minutes. 1440 = 24 * 60.

SteveL13

ASKER

This isn't quite getting it. Again:

If StartTime for example is "4/16/2014 2:53:50 PM"
and
If StopTime for example is "4/16/2014 3:01:05 PM"

then the elapsed hours would be something like .13 right?

How do I get the calculated field to read .13 ?

akb

See attached spreadsheet
Hours.xlsx

ASKER CERTIFIED SOLUTION