Hours worked

  • Thread starter Thread starter That's Confidential
  • Start date Start date
T

That's Confidential

I'm totally new to MS Excel and so would appreciate a little help!

I am trying to work out hours worked, and so need a formula. For example in
column A, i input the start time (24 hr clock) and in column B the finish
time. I would then like column C to then automatically work out the hours
worked.

eg.

A B C
08:00 17:00 9.00

Also, I would like it to work out minutes in 100s (if that makes sense)

eg.

A B C
08:15 17:00 8.75

I would appreciate it if anybody could tell me what formula I should be
entering in column C

Thanks in advance
 
Hi
to get the hours work try
=B1-A1
or if it is possible to work after midnight:
=(B1<A1)+B1-A1

To get the value in decimlas just multiply with 24 and format the
result as 'number':
=(B1-A1)*24
or
=((B1<A1)+B1-A1)*24

Frank
 
That's Confidential said:
I'm totally new to MS Excel and so would appreciate a little help!

I am trying to work out hours worked, and so need a formula. For example in
column A, i input the start time (24 hr clock) and in column B the finish
time. I would then like column C to then automatically work out the hours
worked.

eg.

A B C
08:00 17:00 9.00

Also, I would like it to work out minutes in 100s (if that makes sense)

eg.

A B C
08:15 17:00 8.75
Click to expand...

Have you tried using * sign to multiply?
 
Back
Top