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 variation of, I have tried changing it to 9.3 but can’t then get it to go 9.5. 

​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 variation of, I have tried changing it to 9.3 but can’t then get it to go 9.5.   Read More

​