ProgrosiveTime calculation

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
 
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]
 
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
 
Back
Top