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