Sep 01 2020 02:04 PM - edited Sep 01 2020 02:11 PM
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
Sep 01 2020 02:19 PM
SolutionIn Excel 1 day is equal to 1, thus 1 hour is 1/24, thus
=A1/A2/24
and apply General format to the result.
Sep 01 2020 02:19 PM
SolutionIn Excel 1 day is equal to 1, thus 1 hour is 1/24, thus
=A1/A2/24
and apply General format to the result.