If i have a number in exel lets say 1600 in A1 and want to divide it by a time 10:00:00 In A2 what do i need to do or type?
1600 divided by 10 hours = 160 is the answer i want from my exel sheet in A3
View best response
In Excel 1 day is equal to 1, thus 1 hour is 1/24, thus
and apply General format to the result.