Excel - Time in Minutes between dates
 

Hi,

Can any one help me in calculating time in Minutes between any give
date

--
Message posted from http://www.ExcelForum.com

Excel - Time in Minutes between dates
 

Hi P. Balakrishnan!

With start date in A1 and end date in B1:
=(B1-A1)*24*60

Excel records dates and times as serial numbers where the integer is
number of days from 31-Dec-1899 and the decimal part is the decimal
part of a day.

If the dates include time, you can get the minutes from the above
taking into account the time of day of start date and end date. You
might want to use =NOW() for one of the inputs as, compared with
TODAY(), NOW() takes system date and time.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia

Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

Excel - Time in Minutes between dates
 

A date is stored as a number, with decimal places.

NumberOfDaysBetween = (LastDate - FirstDate)
NumberOfHoursBetween = 24 * NumberOfDaysBetween
NumberOfMinutesBetween = 60 * NumberOfHoursBetween
etc.


-----Original Message-----
Hi,

Can any one help me in calculating time in Minutes
between any given
dates


---
Message posted from http://www.ExcelForum.com/

.