How do I create a formula to calculate amounts of time elapsed in hours in Excel?

Question

I'm trying to create a formula to produce the amount (in hours) elapsed. (example: Cell 1A is 9:00 AM, Cell 2A in 4:00 PM. The formula would be in cell 3A and the result would be 7.
I can only get it to produce the result in a "time" format.

Answer 1

Format Cells 1A and 2A as time.

Format Cell 3A as general then use the formula



=(1A-2A)*24

Answer 2

Select the cell where the results will be and do the following:



Format --> Cells



Make sure you're on the Number tab



Hghlight the Custom format



From the list of Types, choose h:mm



That gives you the difference between the two cells in hours and minutes. Changing the Type to h gives you just the hours.

Answer 3

Right click on the result cell and choose "Format Cells." Under Category, choose Custom. Type in h "hours." This will produce the number 7 followed by the word hours.



If you were finding the distance between two times that aren't right on the hour, you will follow the same steps, except in the Custom format, you would type: h "hours," m "minutes."

Answer 4

for example: X - minutes (on your ex forty 5 minutes) Y - days (on your occasion 3 days) Your formulation is: =X * Y / 60 Your effect is in actuality: forty 5 * 3 / 60 = a hundred thirty five / 60 = 2.25 hours