Using DateDif to calculate minutes

[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

[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!
==============================================

"Joe" <J...@discussions.microsoft.com> wrote in message
news:6C240C68-8454-4663...@microsoft.com...

[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

"Myrna Larson" <anon...@discussions.microsoft.com> wrote in message
news:f7cdn0hakitkquaps...@4ax.com...

[Jamie Collins]

Myrna Larson <anon...@discussions.microsoft.com> wrote ...

> > Can excel use the datedif function to calculate MINUTES?
> > I know that Access can

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

--