thank you for your help.

I knew it was something simple!

What is time saved as, before you multiply it?

Please explain what multiplying it does to the value - Im a little
confused...
--
Dan Walters


"Niek Otten" wrote:

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