Here are some problems that our users have asked and received explanations on
Hi, I need a formula to calculate minutes into hours and minutes. i.e,
0.10
0.20
0.50
= 0.80 mins - need formula to convert to 1.20 - 1hr 20 mins
thank you
Solved by M. C. in 14 mins
Does not convert minutes into hours correctly. Also Need it to round up or down depending if it is 1.37 would convert to 1.00 if it is 1.38 would convert to 1.25.
Solved by I. W. in 14 mins
I need to know how do I convert the data to be in hours/minutes an also add data labels to the sheet
Solved by A. J. in 20 mins
Can you please help me with a formula that will convert ---> 7 days 22 hours 51 minutes 27 seconds 630 milliseconds
to the format dd:hh:mn:sec?
Solved by X. Q. in 23 mins
I need a formula that will convert hours worked into decimal format without seconds. Ex. 9 hrs and 18 minutes (9:18) worked converted to 9.3