# Time worked calculations

#### rbsllc

##### New Member
I am trying to format a timesheet that will calculate start and end times and calculate how many hours worked to calculate earnings? How do I format the start and end time as well as the hours worked?

### 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

#### Jonmo1

##### MrExcel MVP
Welcome to the board...

As long as you enter your times in valid Excel Times, it's pretty easy...

Examples of Valid Excel Time Entries
17:30:00
5:30 PM

Then you can use a very basic formula to calculate how many hours were worked..

A1 = Start Time
B1 = End Time

in C1 put formula
=B1-A1

Hope This Helps..

Replies
2
Views
350
Replies
4
Views
312
Replies
3
Views
227
Replies
2
Views
414
Replies
4
Views
184

1,190,697
Messages
5,982,352
Members
439,776
Latest member
mathewduffy

### 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.

### Which adblocker are you using?

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

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