adding military time format
adding time hh.mm.ss format. I cannot get a sum - only 0
|
Excel probably does not recognize your values as true
time values - just text strings. Try summing them with: =SUMPRODUCT(--SUBSTITUTE(A1:A10,".",":")) and custom format the formula cell as hh.mm.ss . HTH Jason Atlanta, GA -----Original Message----- adding time hh.mm.ss format. I cannot get a sum - only 0 . |
Excel does not recognize hh.mm.ss as time format, hh:mm:ss or use
=SUM(--SUBSTITUTE(A1:A50,".",":")) entered with ctrl + shift & enter use custom format [hh]:mm:ss Regards, Peo Sjoblom "am6160" wrote: adding time hh.mm.ss format. I cannot get a sum - only 0 |
All times are GMT +1. The time now is 01:05 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com