View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Norman Harker Norman Harker is offline
external usenet poster
 
Posts: 162
Default 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.