I need to be able to calculate the length of time (in hours) between two times and dates.
I have four cells, one each for start date and start time as well as end date and end time. Is there an easy way of doing this?
I can work out the number of full days between the dates using =DAYS360 and multiplying it by 24 and get the times by subtracting them to find the hours. But the problem is when it is less than 24 hours.
I know there is a way to do this but my mind has gone blank. Any help would be greatly appreciated.