I have a column A which contains time in this format: 0:00:00.000
Is there any formula that I can use to roundup the said value to say 0 in a different column B?
eg: 0:45:12.111 should be round up to 1
0:23:10.234 Should be round up to 0.5
3:12:15.432 should be round up to 3.5
Every 30mins is to be counted as 0.5
so rounding to the nearest 30 mins?
Formula:
Please Login or Register to view this content.
Last edited by humdingaling; 05-05-2017 at 03:36 AM. Reason: file attached
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
try=CEILING(A1*24,0.5)
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
Or (to get output of 3.5, etc):
=CEILING(24*A1,0.5)
formatted as general
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
Nice! but those always round UP. To round to NEAREST 30 min, try this:
Formula:Please Login or Register to view this content.
Or
Formula:Please Login or Register to view this content.
Last edited by leelnich; 05-05-2017 at 03:51 AM.
Thank You all for the help..
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks