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?
|