I am using times to calculate ratings for my purpose and wonder if anyone can help me with the formulas I need for the following examples which I assume are slightly different :
These first two I assume are the same............
Cell contains time in format 1:45.79 which is 1 minutes 45.79 seconds I want in another cell to calculate the exact number ie 105.79 seconds so I can then divide that answer by, for example, 3 and get 35.26
Cell contains time in format 4:02.84 which is 4 minutes 2.84 seconds I want in another cell to calculate the exact number ie 242.84 seconds so I can then divide that answer by, for example, 5 and get 48.57
And these would be different .........................
Cell contains time in format 15:47.15 which is 15 hours 47 minutes and 15 seconds I want in another cell to calculate the exact number so I can then divide that answer by, for example, 12 and get 1:31.55.
Would this formula be different if it read 15:47.15.75 being 15 hours 47 minutes and 15.75 seconds ?
many thanks
John
Bookmarks