convert to seconds
Anyone know how to convert a time (format= HH:MM:SS) into seconds? example:
1:10:05 = 4205 |
XL stores times as fractional days, so you need to multiply the time by
24*60*60, or =A1 * 86400 In article , Arturo wrote: Anyone know how to convert a time (format= HH:MM:SS) into seconds? example: 1:10:05 = 4205 |
All times are GMT +1. The time now is 05:37 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com