how can i convert a cell formatted as hh:mm:ss to seconds only. ie 00:02:00 returns 120 secs
A Andrew@rushington Nov 30, 2007 #1 how can i convert a cell formatted as hh:mm:ss to seconds only. ie 00:02:00 returns 120 secs
A Andrew@rushington Nov 30, 2007 #3 good old simple mathmatics wins the day!! Thanks David Biddulph said: =A1*24*3600 and format as number or general. Click to expand...
good old simple mathmatics wins the day!! Thanks David Biddulph said: =A1*24*3600 and format as number or general. Click to expand...