ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   how do I add time IE: 916:10+7994:37... if I have a long list? (https://www.excelbanter.com/excel-discussion-misc-queries/26482-how-do-i-add-time-ie-916-10-7994-37-if-i-have-long-list.html)

Pastor J

how do I add time IE: 916:10+7994:37... if I have a long list?
 
I need to add a lot of logged hours. What is the best way to do it? I then
need to subtract yearly hours to see if they went up or down

Bob Phillips

=A1+A2+A3 etc

make sure you format the result as [hh]:mm

subtract uearly hours

=(H1*24)-yearly_hours

and format as General

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Pastor J" <Pastor wrote in message
...
I need to add a lot of logged hours. What is the best way to do it? I

then
need to subtract yearly hours to see if they went up or down





All times are GMT +1. The time now is 11:09 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com