Timesheet

[Legacy 436357]

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
	A	B	C	D	E	F	G	H
3			Time Charged To
4	A/N	Date	AFR Number	Shop Order	Other	Start Time	End Time	Total Time
5	1	7/5/2019				08:00		16:00
Sheet1

 

[Fluff]

How about
=IF(G5="","",IF(G5< F5,G5+1,G5)-F5)

 

[Legacy 436357]

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]

Enter them as 8:00 and format to whatever you want.

 

[Fluff]

However with the formula you are using, you will need to enter time in 24hr format.

 

[Legacy 436357]

I found it thanks I appreciate the help.

How do I mark this as solved?

 

[Fluff]

You're welcome & thanks for the feedback.

We don't marked threads as solved here.