Difference between two times in seconds

  • Thread starter Radhakant Panigrahi
  • Start date
R

Radhakant Panigrahi

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.
 
F

FSt1

hi
use a custom format in A3.
[ss]
this will keep the time from rolling over to minutes and total the seconds.

regards
FSt1
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Difference Between Two Times 5
Seconds 2
% Difference between cells based on variable... 6
Subtract times? 2
Time Difference Formula 3
Difference in Time hour what formula to use in excel? 4
Difference between dates and times 5
years-months-days-hours 8

Top