Hi guys, maybe a simple question but a tough one for some one like me.
I have this data set it is from my phone bill and want to round the numbers up (whole minutes). I did manage to convert the time annotation to decimalsof course with your help but this one seems to be more difficult than I thought.
I want to round 3.25 to 4.00 and 2.55 to 3.00 and 0.15 to 1.00 and so on.
Time Time (decimal)
3:15 3.25
2:33 2.55
7:03 7.05
9:03 9.05
5:38 5.63
0:09 0.15
0:05 0.08
0:55 0.92
0:03 0.05
0:05 0.08
4:29 4.48
1:34 1.57
Can you give me a formula to do this?.
Thank you.
Bookmarks