Using Time in Formulas
Great! Thanks!!!!
"Niek Otten" wrote:
Hi Cheri,
In Excel. time is stored as a fraction of a day.
To get the # of hours, 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
"Cheri" wrote in message ...
| We often get reports where the time is entered as 41:58:00 where the 41 is
| hours, the 58 is minutes and the 00 is seconds. However, this data is copy
| and pasted from another form. It is formatted as: CUSTOM [h]:mm:ss.
| However, when you click on the cell, what you see in the formula line is
| 1/1/1900 5:58:00 PM
|
| How do I use this time to convert to seconds (if necessary to get my final
| per hour answer)? I then need to divide it by the number of papers completed
| within that time frame. Say a rep has completed 314 papers in that length of
| time. I need to show how many papers were completed per hour.
|
| I know this is probably simple to one of you out there, but it has me
| totally confused. Help!!!
|
| Thanks,
| Cheri
|