Using DateDif to calculate minutes

J

Joe

Can excel use the datedif function to calculate MINUTES? I know that Access
can, but I want to use it in Excel.

Thank you
 
R

RagDyer

Chip Pearson's web page on this is quoted in many magazines as the optimum
site for explaining this function

http://www.cpearson.com/excel/datedif.htm
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

Can excel use the datedif function to calculate MINUTES? I know that Access
can, but I want to use it in Excel.

Thank you
 
M

Myrna Larson

No, it can't. But if you have two times, you can subtract and multiply the
result by 1440 to convert the units from days to minutes.
 
P

Peo Sjoblom

Or use custom format [mm] without converting it to decimals

Regards,

Peo Sjoblom


Myrna Larson said:
No, it can't. But if you have two times, you can subtract and multiply the
result by 1440 to convert the units from days to minutes.
Click to expand...
 
J

Jamie Collins

No, it can't. But if you have two times, you can subtract and multiply the
result by 1440 to convert the units from days to minutes.
Click to expand...

I know this is .worksheet.functions but it may be worth pointing out
that the VBA function DateDiff may be used to calculate minutes e.g.
this in the VBE Immediate Window:

? DateDiff("n", Now - 1, Now)
1440

Presumably this is what the OP means by 'I know that Access can' i.e.
MS Access uses the same VBA library as Excel and the VBA5 functions
(as distinct from methods) may be used in Jet queries.

Jamie.

--
 
Top