How do you convert decimal in to numbers

G

Guest

I HAVE CREATED MY OWN SIMPLE TIME SHEET EVERY WEEK MONDAY TO FRIDAY SUCH AS
THIS: BUT WHEN I ADD THE TOTAL HOURS WORKED I AM NOT ABLE TO GET THE ANSWER,
PLEASE HELP WHAT SHOULD I DO???

IN OUT IN OUT TOTAL HRS
6:36 12:00 12:30 17:36 10:30
IN OUT IN OUT
6:36 12:00 12:30 17:36 10:30
IN OUT IN OUT
6:36 12:00 12:30 17:36 10:30
IN OUT IN OUT
6:36 12:00 12:30 17:36 10:30
IN OUT IN OUT
6:36 12:00 12:30 17:36 10:30
 
P

Pete_UK

No need to SHOUT !!

Excel stores time as fractions of a 24-hour day, so what might look
like 12:00 is actually stored internally by Excel as 0.5. Thus you will
need to multiply by 24 to convert the time differences into decimal
hours.

Assuming your data as shown in the example occupies columns A to E, you
can try this formula in E2:

=(B2 - A2 + D2 - C2) * 24

and format the cell as number with 2 decimal places. You should be
aware that 8.25, for example, will represent 8 hours and 15 minutes.

You can copy the formula down to give you a total for each line of data
that you have.

Hope this helps.

Pete
 
B

Bob Phillips

Just add them and format as [h]:mm

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
G

Guest

Sum the column for 5 days that is sum all the 10:30 in your example and then
multiply that by 24 and format it as number
In this example you would see 52.50 hours worked for the week
 
G

Guest

GREAT MANY THANKS

N Harkawat said:
Sum the column for 5 days that is sum all the 10:30 in your example and then
multiply that by 24 and format it as number
In this example you would see 52.50 hours worked for the week
Click to expand...
 
G

Guest

GREAT, MANY MANY THANKS

Pete_UK said:
No need to SHOUT !!

Excel stores time as fractions of a 24-hour day, so what might look
like 12:00 is actually stored internally by Excel as 0.5. Thus you will
need to multiply by 24 to convert the time differences into decimal
hours.

Assuming your data as shown in the example occupies columns A to E, you
can try this formula in E2:

=(B2 - A2 + D2 - C2) * 24

and format the cell as number with 2 decimal places. You should be
aware that 8.25, for example, will represent 8 hours and 15 minutes.

You can copy the formula down to give you a total for each line of data
that you have.

Hope this helps.

Pete
Click to expand...
 
G

Guest

Thanks, but this didn't worked I'm getting 4:30 as the answer. But its ok, I
got my answer from others already. thanks again

Bob Phillips said:
Just add them and format as [h]:mm

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

RICK said:
I HAVE CREATED MY OWN SIMPLE TIME SHEET EVERY WEEK MONDAY TO FRIDAY SUCH AS
THIS: BUT WHEN I ADD THE TOTAL HOURS WORKED I AM NOT ABLE TO GET THE ANSWER,
PLEASE HELP WHAT SHOULD I DO???

IN OUT IN OUT TOTAL HRS
6:36 12:00 12:30 17:36 10:30
IN OUT IN OUT
6:36 12:00 12:30 17:36 10:30
IN OUT IN OUT
6:36 12:00 12:30 17:36 10:30
IN OUT IN OUT
6:36 12:00 12:30 17:36 10:30
IN OUT IN OUT
6:36 12:00 12:30 17:36 10:30
Click to expand...
Click to expand...
 
G

Guest

What do you mean by this
(replace somewhere in email address with gmail if mailing direct) is this
for me, if yes, how to do it.

Bob Phillips said:
Just add them and format as [h]:mm

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

RICK said:
I HAVE CREATED MY OWN SIMPLE TIME SHEET EVERY WEEK MONDAY TO FRIDAY SUCH AS
THIS: BUT WHEN I ADD THE TOTAL HOURS WORKED I AM NOT ABLE TO GET THE ANSWER,
PLEASE HELP WHAT SHOULD I DO???

IN OUT IN OUT TOTAL HRS
6:36 12:00 12:30 17:36 10:30
IN OUT IN OUT
6:36 12:00 12:30 17:36 10:30
IN OUT IN OUT
6:36 12:00 12:30 17:36 10:30
IN OUT IN OUT
6:36 12:00 12:30 17:36 10:30
IN OUT IN OUT
6:36 12:00 12:30 17:36 10:30
Click to expand...
Click to expand...
 
B

Bob Phillips

That's because you ignored what I said. If you had followed it you would
have got 52:30.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

RICK said:
Thanks, but this didn't worked I'm getting 4:30 as the answer. But its ok, I
got my answer from others already. thanks again

Bob Phillips said:
Just add them and format as [h]:mm

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

RICK said:
I HAVE CREATED MY OWN SIMPLE TIME SHEET EVERY WEEK MONDAY TO FRIDAY
Click to expand...
SUCH
AS
THIS: BUT WHEN I ADD THE TOTAL HOURS WORKED I AM NOT ABLE TO GET THE ANSWER,
PLEASE HELP WHAT SHOULD I DO???

IN OUT IN OUT TOTAL HRS
6:36 12:00 12:30 17:36 10:30
IN OUT IN OUT
6:36 12:00 12:30 17:36 10:30
IN OUT IN OUT
6:36 12:00 12:30 17:36 10:30
IN OUT IN OUT
6:36 12:00 12:30 17:36 10:30
IN OUT IN OUT
6:36 12:00 12:30 17:36 10:30
Click to expand...
Click to expand...
Click to expand...
 
B

Bob Phillips

No, ignore it.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

RICK said:
What do you mean by this
(replace somewhere in email address with gmail if mailing direct) is this
for me, if yes, how to do it.

Bob Phillips said:
Just add them and format as [h]:mm

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

RICK said:
I HAVE CREATED MY OWN SIMPLE TIME SHEET EVERY WEEK MONDAY TO FRIDAY
Click to expand...
SUCH
AS
THIS: BUT WHEN I ADD THE TOTAL HOURS WORKED I AM NOT ABLE TO GET THE ANSWER,
PLEASE HELP WHAT SHOULD I DO???

IN OUT IN OUT TOTAL HRS
6:36 12:00 12:30 17:36 10:30
IN OUT IN OUT
6:36 12:00 12:30 17:36 10:30
IN OUT IN OUT
6:36 12:00 12:30 17:36 10:30
IN OUT IN OUT
6:36 12:00 12:30 17:36 10:30
IN OUT IN OUT
6:36 12:00 12:30 17:36 10:30
Click to expand...
Click to expand...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Subtracting time...again 2
How do I find a match for three variables to determine the result? 4
airline standby worksheet 7
how do i do this in excel ? 3
Sum Time 6
Count 1
Timesheet Calculations 3
Converting time to decimal format 17

Top