converting Minutes & Seconds into seconds
Depends upon how the 10 mins 50 secs is entered.
I have 00:10:50 in A1
In B1 enter =A1*86400
I have 10:50:00 in A1
In B1 I enter =A1*1440
Format as General.........returns 650
Gord Dibben MS Excel MVP
On Fri, 11 Dec 2009 10:46:01 -0800, Joe
wrote:
When my time is 10 minutes and 50 seconds how can I convert the time into
seconds?
|