S steve Jul 21, 2008 #1 i am trying to figure out how to add two cell up. example time in and then time out. total hours worked.
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 Jul 21, 2008 #2 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
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
