formula

S

steve

i am trying to figure out how to add two cell up. example time in and then
time out. total hours worked.
 
M

Mike H

Steve

=MOD(B1-A1,1)

Where A1 is the start and B1 is the end
It could be as simple as B1-A1 buth that wouldn't cope with time
before/after midnight

Mike
 
Top