“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

how to show a conversion from litres per minute to cubic metres per hour

Solved by G. W. in 22 mins

Hi, how to calculate the sum of time difference for different person in term of hour minute and sec between the start time and end time?

Solved by B. B. in 17 mins

Hi, may i know how to calculate the time difference in hour minute and sec between the start time and end time under Benny?

Solved by K. L. in 27 mins

I need a macro that would format the selected column as follows; the column lists hours worked in this format 45 minutes = .45, 3 hours and 40 minutes = 3.4, 1 hour and 1 minute = 1.01. I need to format this column so I'll be able to sum up hour and minutes.

Solved by I. J. in 15 mins

I'm using the CEILING formula to calculate the duration between start/end times (round up to each 6 minute increments), in the form of a decimal number. Example, 6:00 to 6:30 is 0.5 hour (=CEILING ((B2-A2)*24, 6/60). For some reason, each 6th minute mark is counted UP, so instead of getting "0.5" I'm getting "0.6"

Solved by V. U. in 12 mins