LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
eacollins
 
Posts: n/a
Default Adding large minute and second values

I'm trying to total a column with large minute values. For example, I want
to add 0:1125325:27 (1,125,325 minutes, 27 seconds) with 0:2358964:18
(2,358,964 minutes, 18 seconds. My total column shows as 00:00, no matter
how I play with the format. I have the individual times formatted as
h:mm:ss, and I have the total column formatted as [mm]:ss so the results will
stay in minutes. However, it's almost like I need to have h:mmmmmmm:ss and
[mmmmmmmm]:ss. However, that's not working for me. If I try to create
h:mmmmmmm:ss, Excel saves it as h:mmmm:ss, and then it reads the 'm' as month
instead of minute. I'm not getting anywhere. If anyone knows how to make
this work, I would really appreciate it.

Thank you!
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 08:10 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"