TIME....again

  • Thread starter Thread starter cellblock
  • Start date Start date
C

cellblock

I've reviewed the posts and tips relating to time, but haven't found an
EXACT answer to what I'm trying to do.

Like one of the other posters, I keep an hourly logbook.

I might enter a start time as 23:30 zulu, and an end time of 01:15
zulu. In this case, the time difference should equal 1:45, and then
converted to tenths should be 1.8. When I'm not starting and ending on
a different zulu day, I'm able to get the function to work perfectly.


BUT HERE'S THE RUB. For DATE, I only wish to enter the local start
date...regardless of what my zulu start or end date is.

As a result, a log entry might look something like this.

25 Jan 04 / 23:30 / 01:15 / 1.8 /

Is there a way to do this WITHOUT entering a start AND end date? So
far, it looks like it's not possible. Industry acceptable logbook
entries do not recognize or accept/expect any more than one entry
date...and usually it's just the local date when the flight began.

Thanks in advance.

Cellblock
 
As long as the elapsed time is <24 hours, use

=(C1-B1+(C1<B1))*24

or
=MOD(C1-B1,1)*24

You can obviously wrap these formulae with ROUND(...,1)
 
Hi
assumption: your are not working more than 24 hours. Try the following:
=IF(B1<A1,B1-A1+1,B1-A1)
A1: start time
B1: end time

For a conversion to decimals use
=IF(B1<A1,B1-A1+1,B1-A1)*24
and format as number/general

HTH
Frank
 
Back
Top