Using Time in Formulas
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
|