Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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/ . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Number of Hours&Minutes between Dates and time | Excel Discussion (Misc queries) | |||
Need to determine the elapsed Minutes between 2 dates in excel | Excel Worksheet Functions | |||
Time inputted as minutes and seconds Excel | New Users to Excel | |||
Using military time but with 100 minutes not 60 minutes | Excel Discussion (Misc queries) | |||
how to subtract time cards in minutes in excel | Excel Worksheet Functions |