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

[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 ?

 

[Frank Kabel]

Hi
AFAIK the maximum for Excel is 9999 hours. Above that you can't use
Excel's date/time values

 

[Guest]

thanks for the advice Frank..oh well

Hi
AFAIK the maximum for Excel is 9999 hours. Above that you can't use
Excel's date/time values

 

[Peo Sjoblom]

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)