Time worked calculated.

Copper Contributor

I have to sign in and out on a Log Sheet using hours and minutes.  What I need someone to how to enter this on an excel speadsheet so at the end of the day it will calculate time work. How will I do this?

 

1 Reply

Hello,

 

if cell A1 has the start time and cell B1 has the end time, you can calculate the elapsed time by subtracting A1 from B1.

 

=B1-A1

 

Format the result as time. If you have several time periods for each day, you need to enter start and end for each time period, then calculate the elapsed time for each of the periods and add the results to arrive at the total for the day.

 

Does that help?