Using DateDif to calculate minutes

[Guest]

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

Thank you

 

[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

 

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

 

[Peo Sjoblom]

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

Regards,

Peo Sjoblom

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.

 

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

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.

--