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