ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   HOW DO I CALCULATE TIME IN A TIME SHEET FOR EXCEL (https://www.excelbanter.com/new-users-excel/32559-how-do-i-calculate-time-time-sheet-excel.html)

RAFAEL

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

Bob Phillips

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





All times are GMT +1. The time now is 10:27 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com