View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Cheri Cheri is offline
external usenet poster
 
Posts: 53
Default 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