calculating time spent working

[tina]

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 .

 

[Frank Kabel]

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

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 .

 

[Norman Harker]

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.