Forum Discussion
Unusual Time format
I have an unusual time format that I would like to add up the hours. So 0930 is 9hours 30 mins and 0415 is 4hours 15mins etc. I have tried changing the format to time and manually tried h:mm and vari...
Another function that could be used is DOLLARDE.
= DOLLARDE(custom/100,60)/24Dividing by 100 places the decimal separator between your hours and minutes. The 60 as a 2nd parameter defines the decimal part to be 60ths of an hour rather than the 100th that is standard for decimal numbers. The result is in units of 1 hour so, to convert to Excel time, divide by 24 to give the time as a fraction of a day.