Hi Everyone,

I need to get the total amount of minutes between two dates which are
formatted as timestamps. I have a Start Date and a End Date. IWhat
function do I use, or, do I use VBA code to get what I want?

Thanks.

One way:

A1: Start timestamp
B1: End timestamp
C1: =(B1-A1)*1440

Since XL stores dates/times as fractional days, you need to multiply the
difference between date/times by 24 hours/day x 60 minutes/hour or 1440.


In article
,
EAB1977 wrote:

Hi Everyone,

I need to get the total amount of minutes between two dates which are
formatted as timestamps. I have a Start Date and a End Date. IWhat
function do I use, or, do I use VBA code to get what I want?

Thanks.

With stamps in A2 and A3:
=ABS(A2-A3)*24*60 and format as Number
--
Gary''s Student - gsnu200819


"EAB1977" wrote:

Hi Everyone,

I need to get the total amount of minutes between two dates which are
formatted as timestamps. I have a Start Date and a End Date. IWhat
function do I use, or, do I use VBA code to get what I want?

Thanks.

And to do days would be:

=ABS(A2-A3)*24 ?