Converting date format into a percentage

[Katie.cryer]

Hi,

I work for a satellite communication company and I have to do a daily report on individual vessels and work out the percentage that they were connected to the satellite.
I am given the start time of when they weren't connected and the time they came back online. I then do a formula to work out how long they were down for. In the next column I have a formula to work out how long they were connected for. All of which is in time format. I then want to have another column which works out the percentage of how long they were connected for. The formula I have been using gives me an incorrect answer and I believe it is because of the date format transferring to percentage. (F2/24)*100 doesn't work.

Does anyone know how to help?

Thanks

Katie

[DBY]

Hello Katie
If you want the percentage of connected time against the total time (disconnected + connected), then try the following formula:

Please Login or Register  to view this content.

Hope this helps.
DBY

[arthurbr]

Which boils down to connected/total giving a dimensionless percentage as needed

[DBY]

Yes, Arthurbr is correct the *24 isn't needed it merely changes the time fraction of a day to its decimal equivalent, e.g. 12:30 becomes 12.5. Sorry for any confusion. My brain is addled and dimensionless!

DBY