Timesheet Calculation

[sammipd]

How can I complete this timesheet? I need Total Time worked (End Time less Start Time less Break) and Total $ Due. I've tried it with the Break as minutes or hours or x24, formatted as h:mm or 0.00. I just can't get there. Can you help?

Date	Start Time	End Time	Break (Minutes)	Break (Hour)	Total Time worked	Total Due ($25/hr)
1/1/2021​	8:00 AM​	4:30 PM​	0.00​	0.00​
1/2/2021​	9:00 AM​	5:30 PM​	30.00​	0.50​
1/3/2021​	9:00 AM​	6:30 PM​	45.00​	0.75​
1/4/2021​	10:00 AM​	7:30 PM​	60.00​	1.00​

 

[Dave Patton]

Date and Time.xlsm
	A	B	C	D	E	F
1	Date	Start	End	Break	Total	Amount
2	1-Jan-21	8:00 AM	4:30 PM	0	8:30	212.50
3	2-Jan-21	9:00 AM	5:30 PM	0:30	8:00	200.00
4	3-Jan-21	9:00 AM	6:30 PM	0:45	8:45	218.75
5	4-Jan-21	10:00 AM	7:30 PM	1:00	8:30	212.50
18b

Cell Formulas
Range	Formula
E2:E5	E2	=C2-B2-D2
F2:F5	F2	=E2*24*25

 

[Candyman8019]

Here's another approach. Format column E as Custom H:MM and use this formula:
=TEXT(C2-B2,"H:MM")-TIME(0,D2,0)
For column E, format it as currency with the formula:
=+E2*24*25

 

[Sufiyan97]

Do you want like this..?

Book3
	A	B	C	D	E	F
1	Date	Start Time	End Time	Break (Minutes)	Total Time worked	Total Due ($25/hr)
2	1/1/2021	8:00	4:30 PM	0:00	8:30	212.5
3	1/2/2021	9:00	5:30 PM	0:30	8:00	200
4	1/3/2021	9:00	6:30 PM	0:45	8:45	218.75
5	1/4/2021	10:00	7:30 PM	1:00	8:30	212.5
Sheet1

Cell Formulas
Range	Formula
E2:E5	E2	=C2-B2-D2
F2:F5	F2	=E2*25*24

 

[Sufiyan97]

Date and Time.xlsm
	A	B	C	D	E	F
1	Date	Start	End	Break	Total	Amount
2	1-Jan-21	8:00 AM	4:30 PM	0	8:30	212.50
3	2-Jan-21	9:00 AM	5:30 PM	0:30	8:00	200.00
4	3-Jan-21	9:00 AM	6:30 PM	0:45	8:45	218.75
5	4-Jan-21	10:00 AM	7:30 PM	1:00	8:30	212.50
18b

Cell Formulas
Range	Formula
E2:E5	E2	=C2-B2-D2
F2:F5	F2	=E2*24*25

Sorry I was trying to solve it while keep this thread opened and when I replied your reply was there already.

Is there any way to delete reply?

 

[Dave Patton]

I do not believe that one can delete the message.

There is no need to be sorry. You provided a solution and the original poster should thank you.

 

[sammipd]

Dave Patton Candyman8019 alidurfani​

Thank you all! All of your solutions worked.

 

[Sufiyan97]

I do not believe that one can delete the message.

There is no need to be sorry. You provided a solution and the original poster should thank you.

Thank you!

 

[Sufiyan97]

I do not believe that one can delete the message.

There is no need to be sorry. You provided a solution and the original poster should thank you.

Thank you!

I do not believe that one can delete the message.

There is no need to be sorry. You provided a solution and the original poster should thank you.

Thank you!