Format cells issue

[ekslit]

Hello Guys,

I m having one column with format cells: [h]:mm (exemple 48:00 which means 48h)
The same column value i divided it by 8 (number of worked hours per day)--> 48:00/8h and it gave 6:00
I want that the result be 6 (6 days) instead of 6:00 . I tried other format cells but not getting this result.

Someone can help me with this please?

 

[Fluff]

Try =A2/8*24 and format as General.

 

[ekslit]

Ok working fine so we dont have choice to make this workaround.
Thanks for your help @Fluff

 

[Fluff]

Not sure what you mean by a workaround.