Hi,
I have a spreadsheet for server downtime and I need to convert the downtime from hh:mm:ss to seconds, I have been using a formula but found this doesn't work in certain circumstances like the one below:
down date downtime up date uptime hh:mm:ss seconds
18/09/2006 00:00:00 24/09/2006 23:59:59 167:59:59 0
The seconds column should have calculated 604799 seconds.
I would appreciate any help, thanks.
John.
I have a spreadsheet for server downtime and I need to convert the downtime from hh:mm:ss to seconds, I have been using a formula but found this doesn't work in certain circumstances like the one below:
down date downtime up date uptime hh:mm:ss seconds
18/09/2006 00:00:00 24/09/2006 23:59:59 167:59:59 0
The seconds column should have calculated 604799 seconds.
I would appreciate any help, thanks.
John.