I'm sure it will be simple but can somebody tell me how to show a decimal number in the Excel [h]:mm format.
I have a time sheet with start time / finish time in short time format. i then have a calculated field showing the diffference i.e. 08:35 I then total these 7 (days of the week) fields...
