#1   Report Post  
Luis
 
Posts: n/a
Default to sum times

how I do to sum times.
ex.: 10:00 + 15:00 = 25:00 Hs.

Tks.
  #2   Report Post  
Harald Staff
 
Posts: n/a
Default

As Nike says: Just do it.

You may have to format the result cell as [h]:mm to prevent a "midnight
reset". Unless you have an available numberformat saying 37:30:55. The
basque have, the danes don't. Go figure.

HTH. Best wishes Harald

"Luis" skrev i melding
...
how I do to sum times.
ex.: 10:00 + 15:00 = 25:00 Hs.

Tks.



  #3   Report Post  
Anne Troy
 
Posts: n/a
Default

Format the resulting cell (25:00) as [h]:mm
See:
http://www.officearticles.com/excel/...soft_excel.htm
************
Anne Troy
www.OfficeArticles.com

"Luis" wrote in message
...
how I do to sum times.
ex.: 10:00 + 15:00 = 25:00 Hs.

Tks.



Reply
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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Subtracting lunch breaks from different shift times badger Excel Discussion (Misc queries) 5 June 27th 05 04:10 PM
Charting and analyzing Times' times data for trends Johnny Excel Discussion (Misc queries) 1 May 5th 05 01:36 AM
Copy from worksheet to another x times Union70 Excel Discussion (Misc queries) 0 March 7th 05 09:03 PM
Formula for averaging times Denise Excel Discussion (Misc queries) 1 January 28th 05 04:05 PM
SUMPRODUCT ON TIMES Bob Phillips Excel Worksheet Functions 1 January 13th 05 05:28 PM


All times are GMT +1. The time now is 04:18 PM.

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

About Us

"It's about Microsoft Excel"