General

Re: Converting decimal to time

AnnaGell — Fri, 24 Jan 2014 10:30:45 GMT

Hi, is there any way to make this work if the original decimal could also be a negative? ie: 3.42 --> 3:25 & -3.42 --> -3:25

Re: Converting decimal to time

haigaiz — Sun, 19 Sep 2010 06:06:28 GMT

Beautiful! I cannot thank you enough for your help!

Re: Converting decimal to time

Jimmy — Sun, 19 Sep 2010 05:58:26 GMT

How's this:

concat(floor(my:hours), ":", substring("0", 1, 1 * ((my:hours * 60 mod 60) < 10)), floor(my:hours * 60 mod 60))

Converting decimal to time

haigaiz — Sun, 19 Sep 2010 03:29:17 GMT

Hi guys, I was wondering if any of you knew how to convert a decimal number to to time? I'm creating a time-sheet and to find the difference between two times I've converted them to seconds and then subtracted one from the other - then divided the result by 3600. I would like to convert this back to a time format so it's a bit easier to see how long you've been at work. So for example: 0.48 would look like this 0:28 1.82 would look like 1:49 It's probably fairly easy but I just can't figure it out! Any help would be greatly appreciated.