View Single Post
Old 01-14-2010, 06:55 PM
Ichigo Ichigo is offline Windows XP Office 2007
Join Date: Jan 2010
Posts: 6
Ichigo is on a distinguished road

If u just want to check the number of hours a person works, u can use
e.g. A2-A1, then in the Format Cells, custom format to [h]:mm

Another method is to use the TIME function.
e.g. =TIME(17,30,0)-TIME(9,25,0). The disadvantage is that it has no cell reference
Reply With Quote