Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
how I do to sum times.
ex.: 10:00 + 15:00 = 25:00 Hs. Tks. |
#2
![]() |
|||
|
|||
![]()
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
![]() |
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Subtracting lunch breaks from different shift times | Excel Discussion (Misc queries) | |||
Charting and analyzing Times' times data for trends | Excel Discussion (Misc queries) | |||
Copy from worksheet to another x times | Excel Discussion (Misc queries) | |||
Formula for averaging times | Excel Discussion (Misc queries) | |||
SUMPRODUCT ON TIMES | Excel Worksheet Functions |