Forum Discussion
Solved
Dividing of a number thru time
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
In Excel 1 day is equal to 1, thus 1 hour is 1/24, thus
=A1/A2/24and apply General format to the result.
1 Reply
In Excel 1 day is equal to 1, thus 1 hour is 1/24, thus
=A1/A2/24and apply General format to the result.