|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
May 11th, 2010, 02:58 PM
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
May 11th, 2010, 03:20 PM
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.
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
