View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Radhakant Panigrahi Radhakant Panigrahi is offline
external usenet poster
 
Posts: 45
Default Difference between two times in seconds

hi i need a favour regarding finding out the time spent between two times in
seconds.

I need the current time like 12:35:45 PM in a cell A1 and after some time
put time in cell A2 as 12:37:50 PM.
I need the shortcut formula for putting in a cells (A1&A2) so that it should
come in Hr: Min: Sec format.

And after that I need the difference of this two times in Seconds (125
seconds above) in cell A3.