SOLVED

Dividing of a number thru time

Copper Contributor

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

1 Reply
best response confirmed by Dankoi (Copper Contributor)
Solution

@Dankoi 

In Excel 1 day is equal to 1, thus 1 hour is 1/24, thus

=A1/A2/24

and apply General format to the result.

1 best response

Accepted Solutions
best response confirmed by Dankoi (Copper Contributor)
Solution

@Dankoi 

In Excel 1 day is equal to 1, thus 1 hour is 1/24, thus

=A1/A2/24

and apply General format to the result.

View solution in original post