J Joe Dec 11, 2009 #1 When my time is 10 minutes and 50 seconds how can I convert the time into seconds?
G Gord Dibben Dec 11, 2009 #2 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
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
