| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
|
#2
|
|||
|
|||
|
=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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| time differences in a column | Excel Worksheet Functions | |||
| Accumulate weekly time to total time in Excel. | Excel Discussion (Misc queries) | |||
| Time Sheet Calculation Help Needed! | Excel Worksheet Functions | |||
| Time Sheets | Excel Discussion (Misc queries) | |||
| unmet challenge | Excel Worksheet Functions | |||
Linear Mode
