Working Week Hours (Format Problems)

[glerwell]

Hi

I having trouble when formatting cells to display the numbers hours that need to be worked for a shift pattern.

The sum is simple (38 hours * 4) / 3 = 50.66

I want this to be displayed in hours and minutes format so it should display 50:40.

What would be the correct format for this. I've tried [H]:mm but that is displaying 1216:00


Thanks

 

[steve the fish]

Divide what you have by 24 then format to:

[h]:mm

 

[glerwell]

Thanks, didn't realise it that simple

 

[steve the fish]

You were working in hours but excel requires it in days to enable you to format as you wanted hence the divide by 24.