What is time saved as, before you multiply it?
Please explain what multiplying it does to the value - Im a little
confused...
Times are stored as a fraction of a 24-hour day. E.g., 6:00 = 0.25, 12:00 =
0.5, 18:00 = 0.75, 24:00 = 1.0. By multiplying by 24, you get the decimal
number of hours, as in, 6:00 * 24 = 0.25 * 24 = 6.0.
See
http://www.cpearson.com/excel/datetime.htm for much more about dates and
times in Excel.
--
Cordially,
Chip Pearson
Microsoft MVP - Excel, 10 Years
Pearson Software Consulting
www.cpearson.com
(email on the web site)
"DanielWalters6" wrote in message
...
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