Hi!
I know how to convert 12:30 into 12,5, but how do I reverse it? I want 12,5 to become 12:30.
This is how I do : =(M11-INT(M11))*24 where M11=12:30
Jonas
Hi!
I know how to convert 12:30 into 12,5, but how do I reverse it? I want 12,5 to become 12:30.
This is how I do : =(M11-INT(M11))*24 where M11=12:30
Jonas
Hi Jonas and Welcome to the Board,
12:30 * 24 = 12.5
12.5 / 24 = 12:30
HTH
Regards, Jeff
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks