Thanks:  0
Likes:  0

1. 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 !

2. 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

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 ?

4. I think you should multiply by 24*60 to get minutes. The difference is calculated in fractions of a day.

Russell

5. 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

6. 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

7. Thanks to All for your help on this one...

I've got it working the way I want now

User Tag List

Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•