i am trying to figure out how to add two cell up. example time in and then
time out. total hours worked.
--
"It were better to be a soldier´s widow than a coward´s wife"
"The onset of bayonets in the hands of the valiant is irresistible"
"Veni, vidi, vici"
(I came, I saw, I conquered)

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" wrote:

i am trying to figure out how to add two cell up. example time in and then
time out. total hours worked.
--
"It were better to be a soldier´s widow than a coward´s wife"
"The onset of bayonets in the hands of the valiant is irresistible"
"Veni, vidi, vici"
(I came, I saw, I conquered)