finishing

Hi I have cells J2 (start time) and K2 (finish time) I need to calculate the time elapsed between the two cell values in hours and minutes but some will be start AM and finishing AM but some will be starting AM but finishing PM. The format of the start/finish is h:mm AM/PM Any help would be...

Were going to have a race. Each person will run a course one at a time, with finishing time being recorded. After finishing time is recorded, the next person will run the course, and then their time will be recorded. Before race ever begins, column A will have names of contestants in the order...

Hi I have a starting time and finishing using tables in 24 hours format I use the formula as =Finishing times - starting times It works for the following times 17:45:00 - 16:20:00 16:20:00 - 11:20:00 21:10:00 - 13:05:00 but it does not work for the following 05:10:00 - 22:15:00 12:55:00 -...

G'day Magicians Everyday I have extensive columns of info like the below... I need to Sort it on the Form column so that the first rows contain the blank cells, followed by rows which contain any cells finishing with an x, followed by rows with cells finishing in x and one number, then x and...