Timesheet

L

Legacy 436357

Guest
Hello,

I am trying to set up a simple time sheet tracker.

How can I enter start and end times and then total the hours for each task. I tried in the below example but appreciate any help on this.

Thanks

Excel Workbook
ABCDEFGH
3Time Charged To
4A/NDateAFR NumberShop OrderOtherStart TimeEnd TimeTotal Time
5
1
7/5/2019
08:00
16:00
Sheet1
 

Some videos you may like

Excel Facts

Square and cube roots
The =SQRT(25) is a square root. For a cube root, use =125^(1/3). For a fourth root, use =625^(1/4).

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
40,719
Office Version
365
Platform
Windows
How about
=IF(G5="","",IF(G5< F5,G5+1,G5)-F5)
 
Last edited:
L

Legacy 436357

Guest
That looks like it will work but how do I enter the times? How are they formatted?

If I enter "8" shouldn't it say 8:00 am if it's before noon?

Thank you
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
40,719
Office Version
365
Platform
Windows
Enter them as 8:00 and format to whatever you want.
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
40,719
Office Version
365
Platform
Windows
However with the formula you are using, you will need to enter time in 24hr format.
 
L

Legacy 436357

Guest
I found it thanks I appreciate the help.

How do I mark this as solved?
 
Last edited by a moderator:

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
40,719
Office Version
365
Platform
Windows
You're welcome & thanks for the feedback.

We don't marked threads as solved here.
 

Watch MrExcel Video

Forum statistics

Threads
1,099,124
Messages
5,466,828
Members
406,501
Latest member
TheoDoc

This Week's Hot Topics

Top