Date and Time Formula

edq

New Member
Joined
Mar 18, 2002
Messages
3
G'Day Excel Gurus...

I'm trying to set up an excel spreadsheet which allows me to calculate the number of minutes between 2 Dates and times.

i.e minutes between 1/03/2002 15:00 and 2/03/2002 15:30

Any Help would be appreciated !
 

Excel Facts

Spell Check in Excel
Press F7 to start spell check in Excel. Be careful, by default, Excel does not check Capitalized Werds (whoops)
You may want to do a search before asking questions; this is a fairly common one.

If A1 contains 1/3/2002 15:00
If B1 contains 2/3/2002 15:30

Format C1 as number with 2 decimals.
Put =(B1-A1)*60

:)
 
Upvote 0
Thanks for your help...

Believe me I've searched EVERYWHERE for an answer to this.

Tried your formula and formated the cell as you mentioned, but it does not do the calculation. Am I missing something ?
 
Upvote 0
I think you should multiply by 24*60 to get minutes. The difference is calculated in fractions of a day.

Russell
 
Upvote 0
Hi edq


If you time and date cells are A1 and A2 you could use:

=MAX(A1:B1)-MIN(A1:B1)

and Custom format the cell as [m]

Or to actually get the real number (as apposed to format) try:

=TEXT(MAX(A1:B1)-MIN(A1:B1),"[m]")*1
 
Upvote 0
Dreamboat's formula is right, you have to multiply by 24 for the difference in day and I wish you will get the answer right.

I use C1=(B1-A1)*60*24

HTH
ernie
 
Upvote 0
Thanks to All for your help on this one...

I've got it working the way I want now
 
Upvote 0

Forum statistics

Threads
1,213,527
Messages
6,114,148
Members
448,552
Latest member
WORKINGWITHNOLEADER

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top