h:mm:ss AM + h:mm:ss AM converted to minutes?

h:mm:ss AM + h:mm:ss AM converted to minutes?

Post by UnlhbiBDYW » Fri, 12 Aug 2005 12:33:04


Hi,

I have a column of data in Excel in the worksheet that is displayed as
"0:00:00" and greater time values beyond 0:00:00 AM up to 2:00:00 AM. In the
"contents bar" it is represented as 12:00:00 AM if in the cell it is 0:00:00.

How can I add the minutes and seconds that have elapsed since 12:00:00 AM
for the whole column and display that as an floating point number
representing the total minutes and seconds that have elapsed past 12 am?

I am not very good with functions. So if you can help me with a VBA answer,
that would be great. Thanks.
 
 
 

h:mm:ss AM + h:mm:ss AM converted to minutes?

Post by Bob Philli » Fri, 12 Aug 2005 17:30:36

Ryan,

I think you just need to sum them and then multiply by 24 (to convert to
hours) then by 60 (to minutes)

=SUM(N1:N6)*24*60

this will give the seconds as a decimal fraction.

--
HTH

Bob Phillips



the
0:00:00.
answer,