Thread: formula
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default formula

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)