Get instant live expert help on minute to hour
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”
Here are some problems that our users have asked and received explanations on
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