me add hours worked tend to bill customers.
For example, 2 hours 23 minutes plus 5 hours and 10 minutes plus 10 hours and 55 minutes ... how long? First you add up the minutes, divided by sixty (minutes that is one hour), add the full hours ... ufff ... I got tired.
There is a trick that EXCEL does it automatically.
Ge-nial.
1 - Set a column for the hours they can add by selecting FORMAT / CELLS / HOUR / TYPE: 37:30:55 (hours: minutes: seconds)
2 - loading data. 3 - Finally, we add as we do with any list of figures.
0 comments:
Post a Comment