.... or =MOD(A2-A1,1)*24 (and format as general or number) if you want the
answer in decimal hours.
--
David Biddulph

"David Biddulph" <groups [at] biddulph.org.uk wrote in message
...
=MOD(A2-A1,1) and make sure the result is formatted as time.

"Marty" wrote in message
...
I am working on a spreadsheet that will calculate the hours worked by a
staff
member.
A1 has the start time of 16:00
A2 has a finish time of 01:30 the next morning.

What is the formula please to work out the hours worked by subtracting A2
from A1?