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

Issue with chart not providing hours and minute properly,
Chart is in sheet "Report" in the bottom called Delay Numbers (HH:MM)
Table used is the bottom table in sheet "Charts"

Solved by Z. E. in 19 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

I need help converting 1 minute data into groups of 5 minute data and then groups of 15 minute data.

Solved by E. L. in 22 mins

I need help converting data that is stored in 1 minute intervals into data that is stored in 5 minute intervals and then into 15 minute intervals.

Solved by T. F. in 15 mins

I want to learn how to add time in excel. Add time spent and get a sum on my billing sheet, but instead of getting a total in 60 minute intervals its totaling it in currency or decimal. So in other words if you add (1.25+1.50) the sum will be 2.75 instead of 3.15.

Solved by M. H. in 30 mins