Hi All,
I would like to know how to change the number which is in hh:mm:ss format to only seconds using single excel formula.
Please find below the example
01:20:35 = 4835.
Hi All,
I would like to know how to change the number which is in hh:mm:ss format to only seconds using single excel formula.
Please find below the example
01:20:35 = 4835.
Last edited by anto1510; 12-15-2010 at 05:01 PM.
Just multiply by 86400 (the number of seconds in a day)
If time is in A1 then use this formula in B1
=A1*86400
format B1 as general
Audere est facere
Thats great thank you
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks