Board index MS EXCEL

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

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,

 
 
 
Top

1. format MM:SS without mm/dd/yyyy/hh:mm:ss?

2. Convert MM:SS to HH:MM:SS

3. Convert hhhh:mm:ss to hh:mm:ss (macro ?)

4. import mm/dd/yyyy hh:mm:ss AM date format

5. Need a Macro to change hhhh:mm:ss (BT format) to hh:mm:ss

6. Convert hh:mm:ss AM/PM into valid time

7. excel formula to convert lat/lon degrees to DDD MM SS.SS?

8. Convert MM:SS to SS

9. converting milliseconds to hh:mm:ss:SSS

10. mm/dd/yyyy hh:mm:ss to mm/dd/yyyy

11. function to convert 'nnnnnnnnnn' ---> 'dd.mm.yy hh:mm:ss'

12. how to convert yyyy-MM-dd HH:mm:ss to java.sql.Date

13. How do I convert a date&time (yyyy-mm-dd hh:mm:ss) to date only?

14. Convert x-axis plot labels from epoch seconds to YYYY-MM-DD HH:mm:ss string?

15. Convert a STRING "DD.MM.AAAA HH:MM:SS" to DATETIME format

All times are UTC
Board index