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
[email protected]
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
