answersLogoWhite

0

Arithmetic works with dates and displays the results as days, so just multiply the result times 24 to get the approximate number of hours between the dates (Excel default format for dates assumes each day has a full 24 hours). If your oldest date is in A1 and your most recent date is in A2, use the following formula to calculate hours between the two dates: =(A2-A1)*24.

If you need to show exact hours between specific times for two dates, just format A1 and A2 to display both date and time (a standard option under cell format for dates SAMPLE: 1/1/09 12:00 AM).

User Avatar

Wiki User

15y ago

What else can I help you with?

Related Questions

A calculation used in excell?

Calculate means Excel will evaluate formulas and functions to display the result. You can turn calculate to manual or auto. When it is on auto, everything is updated in real time. Manual will update when you open Excel or requires to you click the calculate button every time you want to see results.


How do you find mean monthly temperature?

Add the temperatures of all the days in the month. Divide the total by the number of days in the month. The result is your mean temperature.


Lf your cycle is more than 45days what are the safe days and fertile days?

Pretty much all the days are fertile ones but to find out which ones you have, you have to have a doctor monitor you. It can differ from month to month.


16 months equal how many days?

To find out how many days are in 16 months, we'll use the average number of days in a month, which is approximately 30.44 days per month. 16 months × 30.44 days/month ≈ 487.04 days 16 months×30.44 days/month≈487.04 days So, 16 months is approximately equal to 487 days.


How do you find how many months and days from June 15 2009 to March 7 2010?

Months are not a fixed number of days, but March 7, 2010 was 8 months and 20 days after June 15, 2009. The calculation uses "full months" of various lengths, ending with the 8th full month on February 15, 2010. From there, you have 13 days more in February and 7 in March. The actual number of days not including the starting day is 264 days.


How many months and days are there in 800 days?

There are approximately 26.28 months in 800 days. (26 months, 8 or 9 days). A month is not a fixed length, but averages about 30.4 days. The 800 days can be divided easily by 365.25 days per year, and multiplied by 12 to find the closest month value.


How many days in salary calendar month?

the answer is within you look deep inside and you too will find the answer...


What is a formula and why do you use them?

If you are talking about math, a formula is a representation of some type of operation, usually between numbers. An example of a formula in Excel is: =12*(34+14). Use use them to find a result of some type of calculation.


How do you input the marginal product equation in excel?

how do you find marginal product on excel


Where can you find a database?

on Microsoft excel you can find a database.


How do you create an Excel List?

You can create Custom Lists and do things like sort them or get calculations from them. You can get them to generate themselves automatically when you type in one value and then drag down. Excel has a number of in-built custom lists. If you type in any day of the week or any month of they year into a cell, and then click and drag on the fill handle, it will fill out subsequent days or months. You will find Custom Lists on the Tools menu under Options.


Where can a person find information on the specifications of a Hyundai Excel?

They can easily be attained from redbook. You can get al the inormation you need from You can find the specifications of a Hyundai Excel from there. Find it there