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

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

--
Regards
Frank Kabel
Frankfurt, Germany
"Mike" schrieb im Newsbeitrag
...
Trying to create a spreadsheet using military time
EX: start 2030 (Dec 25) end time 1500 (Dec 26) need formaul to
calulate total hours

This sugestion dos not seem to work in my swedish XL/(OS?(XP))
"Frank Kabel" skrev i meddelandet
...
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

--
Regards
Frank Kabel
Frankfurt, Germany
"Mike" schrieb im Newsbeitrag
...
Trying to create a spreadsheet using military time
EX: start 2030 (Dec 25) end time 1500 (Dec 26) need formaul to
calulate total hours

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

--
Regards
Frank Kabel
Frankfurt, Germany
"Stefan Lewold" schrieb im Newsbeitrag
...
This sugestion dos not seem to work in my swedish XL/(OS?(XP))
"Frank Kabel" skrev i meddelandet
...
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

--
Regards
Frank Kabel
Frankfurt, Germany
"Mike" schrieb im Newsbeitrag
...
Trying to create a spreadsheet using military time
EX: start 2030 (Dec 25) end time 1500 (Dec 26) need formaul to
calulate total hours

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

--

HTH

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


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

Thanks,
where can I find documentation of this (RTFM?)
Regards


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

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.

--
Regards
Frank Kabel
Frankfurt, Germany

Stefan Lewold wrote:
Thanks,
where can I find documentation of this (RTFM?)
Regards


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!