Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Difference between two times in seconds
hi
use a custom format in A3. [ss] this will keep the time from rolling over to minutes and total the seconds. regards FSt1 "Radhakant Panigrahi" wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Difference in Days, Hours, Minutes and Seconds | Excel Discussion (Misc queries) | |||
Average for times using minutes and seconds | Excel Worksheet Functions | |||
Calc minutes and seconds difference | Excel Worksheet Functions | |||
How do you add five seconds to a series of times? | Excel Discussion (Misc queries) | |||
How do I enter minutes and seconds (lap times)? | Excel Discussion (Misc queries) |