ExcelBanter - additing time in excel

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - additing time in excel (https://www.excelbanter.com/excel-discussion-misc-queries/93362-additing-time-excel.html)

Virender

additing time in excel

how to add time worked each day over 1 year. Example: using sum function to
add 8:45+9:30+7:15 results in 1:30 i want it to show 25:30

KellTainer

additing time in excel

Custom format the resultant cell as [h]:mm

--
KellTainer
------------------------------------------------------------------------
KellTainer's Profile: http://www.excelforum.com/member.php...o&userid=34322
View this thread: http://www.excelforum.com/showthread...hreadid=550863

All times are GMT +1. The time now is 11:38 AM.