Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 32
Default 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?

  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2,118
Default 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?





  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 32
Default 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?






  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2,118
Default 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?








Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Calculating Regular time, overtime and double time Brian Smith Excel Worksheet Functions 5 November 9th 07 11:32 PM
Calculating productivity: widgets per hour ClarkeTeam Excel Worksheet Functions 5 July 10th 07 02:28 AM
calculating timesheet, time-in/time-out = total hours & minutes, . Steve Lindsay Excel Worksheet Functions 13 November 8th 06 04:45 PM
Calculating days & time left from start date/time to end date/time marie Excel Worksheet Functions 7 December 7th 05 03:36 PM
Calculating effective time from start/end date+time Stefan Stridh Excel Worksheet Functions 8 November 27th 04 04:50 PM


All times are GMT +1. The time now is 11:12 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"