Timekeeping

**cbdeajr** · 01-07-2010, 07:36 PM

My grandson is trying to use Excel program to keep track of the hours he is working. I know there is a way to do it but it has been many years since I used Excel and can not remember how to do it. He would like to insert the time (hours & minutes) he works in column A and have a sum in the next column.
Thanks

**HOT97ECLIPSEGSX** · 01-07-2010, 07:56 PM

This one is easy, but before I give you an answer, let me ask you this:

Is he entering the time as hours and minutes as 8.25 hours for 8 1/4 hours, or is he entering it as 8 hours (one column), 15 minutes (one column)?

**pike** · 01-07-2010, 07:56 PM

hi cbdeajr
You will need to coustom format the cells [hh]:mm then subtract and sum ect.. ring any bells?

**cbdeajr** · 01-07-2010, 08:36 PM

He is entering 8:20 for 8 hr 20 min in one column

**HOT97ECLIPSEGSX** · 01-07-2010, 08:40 PM

Originally Posted by cbdeajr

He is entering 8:20 for 8 hr 20 min in one column

You can use what Pike suggested to do what you need to do.

**cbdeajr** · 01-08-2010, 05:25 AM

Sorry, I had a stroke in 08 and I can not get this right. I thought I understod Pikes answer but I can not get it right.

**rwgrietveld** · 01-08-2010, 05:35 AM

Time and date are funny types in excel. It is not an absolute, but a point in time.

For Date that is the number of days since 00/01/1900. Current date = Today() or =Int(Now())
For Time that is a Fraction of 1 (day) 0.5 meaning 12:00

What the post before are tryng to say is that there is a big difference between 8 and 08:00 as the first (8) is 8 days.

08:00 is a custom format time for the value 8/24 = 0.3333

Countin with hours should therefore be done with
="08:00"+"06:00"

or

=8/4 + 6/24

Both formats (cell formatting) should be [h]:mm:ss

the [h] makes sure that time is represented as 25:10 instead of 1:00 as the fraction > 1

**pike** · 01-08-2010, 05:37 AM

Hey cbdeajr
Have a look at the example
Hope it helps

lslisa · 07-26-2011, 07:00 AM

Our time and attendance system is totally optimized for multiple sites, multiple time zones and multiple languages. There are many features that allow you to configure the application to fit your solution needs

web time clock