Tracking time

lionstud31

Board Regular
Joined
Oct 16, 2006
Messages
89
Is there a formula that can calculate my time at work.
column A is arrival time. B is the time I leave for Lunch. C is time I get back from lunch. And D is the time I leave work. Is there a formula I can use to make it calculate it to the nearest hundreth
 

Excel Facts

Back into an answer in Excel
Use Data, What-If Analysis, Goal Seek to find the correct input cell value to reach a desired result

Macropheliac

Board Regular
Joined
Aug 26, 2005
Messages
165
Assuming your ranges are in columns A1,B1,C1,D1 and your result is in column E1.

Format each cell as Time 13:30 and paste into E1:
Code:
=D1-A1-(C1-B1)
 

A1058

New Member
Joined
Sep 13, 2006
Messages
46
seems too easy?? put total hours in column E format the row that will contain results to time format like hh:mm:ss total hours = finish time-start time-(endlunch-startlunchtime) if the result would ever be more than 24 hours worked the format hh:mm:ss would roll over its limited to 24 hour clock but you could choose time format and pick the one from list that shows 37:30:55 or something like this. most ppl wont work so many hours though.
 

Watch MrExcel Video

Forum statistics

Threads
1,133,465
Messages
5,658,938
Members
418,477
Latest member
coutinhoicaro

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top