calculating time spent working

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm new to excel and would like my spreadsheet to calculate the time spent working i.e. I would like to enter time started in A1, time finished B1 and then in C1 enter a function to calculate the hours and minutes which have passed .
 
Hi
simply enter in both cells your times.
e.g.
A1: 08:00
B1: 16:30

In C1 enter the formula
=B1-A1

or if your working time can span midnight use
=B1-A1+(B1<A1)

format the resulting cell as Time

--
Regards
Frank Kabel
Frankfurt, Germany

tina said:
I'm new to excel and would like my spreadsheet to calculate the time
Click to expand...
spent working i.e. I would like to enter time started in A1, time
finished B1 and then in C1 enter a function to calculate the hours and
minutes which have passed .
 
Hi Tina!

Make sure that you input the times in the format recognised as time by
Excel:

eg
A1:
8:00
B1
18:30

Then the difference can be calculated using either of the following:

=B1-A1+(B1<A1)
Or
=MOD(B1-A1,1)

Both formulas address the possibility of the B1 being after midnight.
If the times are more than 24 hours apart, you should include the date
in both time inputs.
 
Back
Top