Hours and Minutes in Excell working with 5 digits hhhhh:mm

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

Guest

I use a spreadsheet at work to record aircraft flying hours in the hours and
minutes format i.e 8475:45 if then i fit a component with a life of
3000:00 hrs and then want a figure of when the component is due to be changed
then excell has a major problem with adding the two values together how can i
use 5 digits for the hours any ideas ?
 
Hi
AFAIK the maximum for Excel is 9999 hours. Above that you can't use
Excel's date/time values
 
Actually you can use it this way

=8475/24+"0:45"+3000/24

formatted as [h]:mm will return 11475:45



--
Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)
 
Back
Top