ProgrosiveTime calculation

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Karthik - 10 May 2005 20:34 GMT

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.

Reply to this Message

Ofer - 10 May 2005 21:31 GMT

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.

Reply to this Message

John Vinson - 11 May 2005 01:06 GMT

>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.

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]

Reply to this Message

Ed Robichaud - 11 May 2005 15:18 GMT

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

>I want to design a access database for aircraft flying hours calculation,
>in
[quoted text clipped - 4 lines]
> hrs.
> please help. Thank You.

Reply to this Message