Time tracking

Emoncada

Active Member
Joined
Mar 23, 2005
Messages
409
I have a spreadsheet that I need to track time on a daily basis. It's a simple spreadsheet
example:

......Monday......Tuesday......Wednesday.......Thurs...Fri.....Sat.....Sun etc..
IN
OUT
IN
OUT
Tot.

I would like for the time I put in the Out for Monday subract from the In on Monday and give me the total time. (But all in Time Format so when 60 Minutes hit then it becomes one hour, and I don't want to use military time)

Example

IN.......8:00
Out.....1:30
IN......
Out.....

Tot.....5:30

And then continue when I come back and have those numbers also included. Any Ideas?
 

Excel Facts

What does custom number format of ;;; mean?
Three semi-colons will hide the value in the cell. Although most people use white font instead.

Dufus

Board Regular
Joined
Aug 19, 2006
Messages
176
Emoncada,

Set up the cells that you record the INs and Outs in to have a time format.

Set up the cell that you want the elapsed time to be in as a time format also.

Use this formula in the cell for the elapsed time:
LastOut-LastIn+FirstOut-FirstIn

If you don't like the format you chose for the elapsed time, do Format Cells and pick another one (time only) or create one of your own. Excel will handle the math automatically.

Dufus
 

Emoncada

Active Member
Joined
Mar 23, 2005
Messages
409
The Total is coming out as a date format I would like it to give me a total hours like 8 hrs, or 7:45 hrs.
 

Forum statistics

Threads
1,136,350
Messages
5,675,246
Members
419,557
Latest member
razlevav

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