Excel help please

chili

chili

chili

Associate
Joined
19 Mar 2011
Posts
816
This is probably really simple, but i cannot get it to produce the right result.
i want to keep a track of my daily hours at work, driving etc i need them to add up in a column as i input them over the course of the month
my input is in the form of 9.15 or 9.30 7.15 8.15 8.30 etc these are hours and minutes 8hr 30nins 7hr 15min and so on. i just want these to add up to a running total ie 144hrs 15 minutes.

can anyone figure this out for me please

cheers
 
Record your time in the format hh:mm in each cell.

So 09:15

Then select the column and change format to Time. (In my version of office its on the ribbon in the group called number select the dropdown box).
In whichever cell you want to add it all up to use the formula =SUM()
And update the range in the brackets to be your array of inputs (i.e. A2:A30)
 
For the columns that you input your clock in/out times custom format them to: [h]:mm

Then simple add / subtract the cells to and from each other to calculate hours worked for that day.

IN AM|Lunch OUT|LUNCH IN|LUNCH TOT|OUT PM|TOTAL
09:00 |13:00 |13:30|00:30|17:00|07:30

The formula in the cell to calculate total is: =((E3-A3)-D3)
 
You must log in or register to reply here.
Back
Top Bottom