Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Total Number of shifts calculation
Hi,
Can someone please help me with a formula to convert following Total hours worked into total nimbers of shifts @ 8 hours eg. 133:42:40 = 16.7 Shifts Thanks! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Total Number of shifts calculation
Smirre wrote:
Can someone please help me with a formula to convert following Total hours worked into total nimbers of shifts @ 8 hours eg. 133:42:40 = 16.7 Shifts The cell(s) that have the shifts need to be formatted as "Number", then just multiply the time worked by 3. -- Everyone's dead except Australia, and they're still like, "WTF?" ....but they'll be dead soon. ****ing kangaroos. |
#3
|
|||
|
|||
Quote:
Assuming that the data is in A1. =ROUND(A1*24/8,1) |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Total Number of shifts calculation
Kevin@Radstock wrote:
Auric__;1622733 Wrote: Smirre wrote: - Can someone please help me with a formula to convert following Total hours worked into total nimbers of shifts @ 8 hours eg. 133:42:40 = 16.7 Shifts- The cell(s) that have the shifts need to be formatted as "Number", then just multiply the time worked by 3. -- Everyone's dead except Australia, and they're still like, "WTF?" ....but they'll be dead soon. ****ing kangaroos. Okay, I know excelbanter is a web forum and not a real Usenet client, but does it really include the sig in quoted text? Keven, in the future, please remove sigs from your quoted text. (Everything after the "-- ".) ....Also, nice censorship, excelbanter. Makes me want to do a post of nothing but swear words, just to fill your db with *really* useless data. Hi Assuming that the data is in A1. =ROUND(A1*24/8,1) ....and 24/8 = 3, which is what I said. [shrug] -- A very wise person once said that a married man can be either right or happy but never both at the same time. Never have truer words been spoken. |
#5
|
|||
|
|||
Quote:
In future spell my name correctly. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculation of Monthly No. of shifts available per operator forunloading work | Excel Programming | |||
Number of total calculation functions | Excel Worksheet Functions | |||
Pay rate Calculation for different shifts | Excel Worksheet Functions | |||
Calculation total not to exceed a specified number. | Excel Programming | |||
Count number of shifts... | Excel Programming |