Get instant live expert help on minute to decimal chart
“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
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