Convert TimeStamp to Minutes


E

EAB1977

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

Advertisements

J

JE McGimpsey

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

Gary''s Student

With stamps in A2 and A3:
=ABS(A2-A3)*24*60 and format as Number
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top