ProgrosiveTime calculation

K

Karthik

I want to design a access database for aircraft flying hours calculation, in
which i need to keep record of daily flying hours and that has to be
cummulatively added and processed for various needs.
Basically I could not find any functions or methods to add time beyond
24:00, whereas I need to add time in hhhhhh:mm format at least in 100000 hrs.
please help. Thank You.
 
O

Ofer

You can use the datediff to get the time between flights, in minutes, houres,
dats
Sum thet field to get the total hours for a day.
 
J

John Vinson

I want to design a access database for aircraft flying hours calculation, in
which i need to keep record of daily flying hours and that has to be
cummulatively added and processed for various needs.
Basically I could not find any functions or methods to add time beyond
24:00, whereas I need to add time in hhhhhh:mm format at least in 100000 hrs.
please help. Thank You.
Click to expand...

Access Date/Time fields are good for storing specific moments in time,
but (as you have found) not so good at storing durations. I would
strongly suggest storing your flying *minutes* - perhaps using two
unbound textboxes for hours and minutes, with a little simple VBA code
to calculate 3 hours 42 minutes into 222 minutes.

You can display a duration stored in minutes in hh:nn format using an
expression

ShowTime: [FlightTime] \ 60 & Format([FlightTime] MOD 60, "\:00")


John W. Vinson[MVP]
 
E

Ed Robichaud

If you're using an ACARS method (out/off/on/in) to log times, then just
store the times and use the DateDiff function to calculate duration.

If you're logging duration, then I suggest data entry in hours and tenths
(i.e. 3 hrs 23 min = 3.4 hrs) like the military does. This will allow for
easy math calculations, like total hours.

-Ed
 
Top