Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
TIME FORMATS IN EXCEL
I AM TRYING TO FORMULATE A SPREADSHEET
EXAMPLE: 36.5 HRS PLUS .45 MINUTES TO EQUAL A TOTAL; THEN TO DIVIDE THE # OF PCS, SUCH AS 21 INTO THE TOTAL TIME TO FIGURE OUT HOW MUCH TIME IT TOOK TO DO EACH PIECE IN PRODUCTION. DO I FORMULATE THE COLUMNS FOR TIME OR JUST STANDARD. MY CALCULATIONS ARE NOT COMING OUT CORRECTLY. THANKS ANNIE828 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
TIME FORMATS IN EXCEL
First of all please do not post in all upper case letters, in the NG's it is
considered SHOUTING and it is more difficult to read especially people whose 1st language is not English. EXAMPLE: 36.5 HRS PLUS .45 MINUTES TO EQUAL A TOTAL By 36.5 do you mean 36 hours and 30 minutes? If so format the cell as custom format [h]:mm:ss then enter the time with a colon between the hours and minutes. If you are using B2 for that entry and B3 for 0:45 (forty-five minutes) then the total in C2 (custom formatted as [h]:mm:ss ) will be: =B2+B3 And will display as: 36:15:00 if you want to divide this time by 21 and have the answer still in C2 then the formula will be: =(B2+B3)/21 or if the 21 is entered in D2: =(B2+B3)/D2 The parentheses are required because the order of calculation in Excel is division the addition so without the parentheses Excel would divide B3 by 21 then add B2 to it. Check out: http://www.cpearson.com/Excel/datetime.htm#AddingTimes -- HTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk "ANNIE828" <u38762@uwe wrote in message news:7aa1b16cc78b4@uwe... I AM TRYING TO FORMULATE A SPREADSHEET EXAMPLE: 36.5 HRS PLUS .45 MINUTES TO EQUAL A TOTAL; THEN TO DIVIDE THE # OF PCS, SUCH AS 21 INTO THE TOTAL TIME TO FIGURE OUT HOW MUCH TIME IT TOOK TO DO EACH PIECE IN PRODUCTION. DO I FORMULATE THE COLUMNS FOR TIME OR JUST STANDARD. MY CALCULATIONS ARE NOT COMING OUT CORRECTLY. THANKS ANNIE828 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
TIME FORMATS IN EXCEL
Thanks for your help!!!! I really appreciate it!
Sandy Mann wrote: First of all please do not post in all upper case letters, in the NG's it is considered SHOUTING and it is more difficult to read especially people whose 1st language is not English. EXAMPLE: 36.5 HRS PLUS .45 MINUTES TO EQUAL A TOTAL By 36.5 do you mean 36 hours and 30 minutes? If so format the cell as custom format [h]:mm:ss then enter the time with a colon between the hours and minutes. If you are using B2 for that entry and B3 for 0:45 (forty-five minutes) then the total in C2 (custom formatted as [h]:mm:ss ) will be: =B2+B3 And will display as: 36:15:00 if you want to divide this time by 21 and have the answer still in C2 then the formula will be: =(B2+B3)/21 or if the 21 is entered in D2: =(B2+B3)/D2 The parentheses are required because the order of calculation in Excel is division the addition so without the parentheses Excel would divide B3 by 21 then add B2 to it. Check out: http://www.cpearson.com/Excel/datetime.htm#AddingTimes I AM TRYING TO FORMULATE A SPREADSHEET [quoted text clipped - 10 lines] ANNIE828 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Converting time formats into actual time(minutes) | Excel Discussion (Misc queries) | |||
Time formats in Excel | Excel Discussion (Misc queries) | |||
Help with time formats | Excel Worksheet Functions | |||
time formats | Excel Discussion (Misc queries) | |||
Time formats in Excel 2003 | Excel Discussion (Misc queries) |