Calculating productivity by time

[Taylor]

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?

 

[Ron Coderre]

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]

Perfect!!
Thanks!

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)

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?

 

[Ron Coderre]

You're welcome!....I'm glad I could help.
--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)

Perfect!!
Thanks!

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)

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?