Extracting number of hours as decimal...
Hi Dan,
Multiply by 24 and format as General or Number, not as Time (which is what Excel does automatically)
--
Kind regards,
Niek Otten
Microsoft MVP - Excel
"DanielWalters6" wrote in message
...
|I have a list of start and finish times.
|
| I've subtracted the finish time from the start time to get the number of
| hours an employee has worked.
|
| This number of hours is given as 6:15 or 7:30, from this, how can I extract
| 6.25 or 7.5?
|
| thank you for your help!
|
|
| --
| Dan Walters
|