Thread: time to seconds
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Peter T Peter T is offline
external usenet poster
 
Posts: 5,600
Default time to seconds

Are those times as strings or time-values with a custom number-format. If
the latter multiply by (24*60*60)

Regards,
Peter T

"inungh" wrote in message
...
I have a spreadsheet which contains time information like follwoing
format

0h 15m 35s
7h 1m 5s

and I would like to convert in seconds,

Are there any functions or formula to do this?


Your help is great appreciated,