Thread: Time
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
T. Valko T. Valko is offline
external usenet poster
 
Posts: 15,768
Default Time

Try this:

=MOD(B1-A1,1)*24

Format as GENERAL or NUMBER

--
Biff
Microsoft Excel MVP


"Troy2006" wrote in message
...
How can I subtract two cells that have a 12-hour time format and return a
value of toal hours within this range in decimal form such as 8.3 hours?