Programming using military time

[Guest]

Trying to create a spreadsheet using military time
EX: start 2030 (Dec 25) end time 1500 (Dec 26) need formaul to
calulate total hours

 

[Frank Kabel]

Hi
one way (start time in A1, end time in B1):
=MOD(TEXT(B1,"00\:00")-TEXT(A1,"00\:00"),1)
and format as time

 

[Stefan Lewold]

This sugestion dos not seem to work in my swedish XL/(OS?(XP))

 

[Frank Kabel]

Hi
try this:
=REST(TEXT(B1;"00\:00")-TEXT(A1;"00\:00");1)

 

[Bob Phillips]

How about just =B22-A22 and format as [hh]:mm

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Stefan Lewold]

Thanks,
where can I find documentation of this (RTFM?)
Regards
(e-mail address removed)

 

[Frank Kabel]

Hi
probably best thing is this NG. And some good websites such as:
http://www.cpearson.com/excel/datetime.htm

AFAIK the only book for advanced formulas is John Walkenbachs 'Formulas for
Excel' book.