ExcelBanter - TIME FORMATS IN EXCEL

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - TIME FORMATS IN EXCEL (https://www.excelbanter.com/excel-discussion-misc-queries/164614-time-formats-excel.html)

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

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

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

TIME FORMATS IN EXCEL