![]() |
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 |
=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