Excel - Time in Minutes between dates

  • Thread starter Thread starter P.Balakrishnan
  • Start date Start date
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
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
A date is stored as a number, with decimal places.

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Time Now() minus ten minutes 1
Time 6
Time durations in excel and VB 1
Need help calculating time in VBA 1
hours / minutes 3
Pivot table macro filter data between yesterday and today (date+time) 0
Calculate times between dates and times in Excel 1
Calculate the number of hours between two dates and times 1

Back
Top