Calculating productivity by time
I'm presented with time in [h]:mm:ss format, ie. 856:25:57, and with a total
productivity number, ie. 1257. Is there a formula to calculate how many per hour, given this format? If not, what is the best way to convert that cumulative time into a decimal? |
Calculating productivity by time
With
A1: 2/4/1900 4:25:57 PM......displayed as 856:25:57 B1: 1257 Regardless of the display format....Excel stores the date/time values as a number with digits to the left of the decimal point = days and digits to the right of the decimal point = decimal fractions of a day. The actual decimal value of cell A1 is: 35.6846875 Consequently, this formula returns the production per hour: =B1/(A1*24) In the above example, the formula returns 1.46771636994159 (per hour) Does that help? -------------------------- Regards, Ron Microsoft MVP (Excel) (XL2003, Win XP) "Taylor" wrote in message ... I'm presented with time in [h]:mm:ss format, ie. 856:25:57, and with a total productivity number, ie. 1257. Is there a formula to calculate how many per hour, given this format? If not, what is the best way to convert that cumulative time into a decimal? |
Calculating productivity by time
Perfect!!
Thanks! "Ron Coderre" wrote: With A1: 2/4/1900 4:25:57 PM......displayed as 856:25:57 B1: 1257 Regardless of the display format....Excel stores the date/time values as a number with digits to the left of the decimal point = days and digits to the right of the decimal point = decimal fractions of a day. The actual decimal value of cell A1 is: 35.6846875 Consequently, this formula returns the production per hour: =B1/(A1*24) In the above example, the formula returns 1.46771636994159 (per hour) Does that help? -------------------------- Regards, Ron Microsoft MVP (Excel) (XL2003, Win XP) "Taylor" wrote in message ... I'm presented with time in [h]:mm:ss format, ie. 856:25:57, and with a total productivity number, ie. 1257. Is there a formula to calculate how many per hour, given this format? If not, what is the best way to convert that cumulative time into a decimal? |
Calculating productivity by time
You're welcome!....I'm glad I could help.
-------------------------- Regards, Ron Microsoft MVP (Excel) (XL2003, Win XP) "Taylor" wrote in message ... Perfect!! Thanks! "Ron Coderre" wrote: With A1: 2/4/1900 4:25:57 PM......displayed as 856:25:57 B1: 1257 Regardless of the display format....Excel stores the date/time values as a number with digits to the left of the decimal point = days and digits to the right of the decimal point = decimal fractions of a day. The actual decimal value of cell A1 is: 35.6846875 Consequently, this formula returns the production per hour: =B1/(A1*24) In the above example, the formula returns 1.46771636994159 (per hour) Does that help? -------------------------- Regards, Ron Microsoft MVP (Excel) (XL2003, Win XP) "Taylor" wrote in message ... I'm presented with time in [h]:mm:ss format, ie. 856:25:57, and with a total productivity number, ie. 1257. Is there a formula to calculate how many per hour, given this format? If not, what is the best way to convert that cumulative time into a decimal? |
All times are GMT +1. The time now is 04:40 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com