Remember Me?

#1
June 26th 05, 10:47 PM
 RAFAEL Posts: n/a
HOW DO I CALCULATE TIME IN A TIME SHEET FOR EXCEL

I AM TRYING TO CALCULATE THE NUMBER OF HOURS WORKED AND THEN SUBTRACTING THE
HOURS TAKEN FOR LUNCH FOR 1 WEEK. FOR EX

CELL 1
MOND. TUE WED
THUR FRIDA
HR IN 10
HR LUN 1
HR BACK 2
HR OUT 6

WHEN I TRY TO CALCULATE THESE HOURS I GET A WRONG ANSWER. I MIGHT HAVE A
PROBLEM WITH THE FORMULA. I TRIED SWITCHING THE HOURS TO MILITARY TIME AND
STILL DID NOT GET THE ANSWER I WANTED

#2
June 26th 05, 11:32 PM
 Bob Phillips Posts: n/a

For each day, use

=(B3-B2)+(B5-B4)

This will return a time amount, so you would need to format the cell, say
B6, as time. If you want decimal hours, multiply by 24.

--

HTH

RP
(remove nothere from the email address if mailing direct)

"RAFAEL" wrote in message
...
I AM TRYING TO CALCULATE THE NUMBER OF HOURS WORKED AND THEN SUBTRACTING

THE
HOURS TAKEN FOR LUNCH FOR 1 WEEK. FOR EX

CELL 1
MOND. TUE WED
THUR FRIDA
HR IN 10
HR LUN 1
HR BACK 2
HR OUT 6

WHEN I TRY TO CALCULATE THESE HOURS I GET A WRONG ANSWER. I MIGHT HAVE A
PROBLEM WITH THE FORMULA. I TRIED SWITCHING THE HOURS TO MILITARY TIME AND
STILL DID NOT GET THE ANSWER I WANTED

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post Chris Excel Worksheet Functions 0 June 9th 05 02:30 AM JenMo Excel Worksheet Functions 1 June 7th 05 06:23 PM Kim Excel Discussion (Misc queries) 2 March 15th 05 09:04 PM Ken Excel Worksheet Functions 1 February 20th 05 09:07 PM liam Excel Worksheet Functions 3 February 16th 05 07:52 PM

All times are GMT +1. The time now is 04:24 AM.