Convert time

[Eric_Penn]

I’ve used Chuck’s solution before

Time duration not presenting correctly in glide chart

I took it a step further and included Days as well. You can exclude it if you don’t need it. It’s a little involved, but I’ll explain the best I can. Here is my results: [image] First we have the Duration column, which is obvious and what you already have. Next we have the Days column: [image] FLOOR(D)/100 This is simply taking the duration and dropping off the decimals. The division by 100 will be explained later. Next we have the Hours column: [image] FLOOR(MOD(D,1)*24)/100 Th…