Making a simple timesheet in Numbers...

[Mavimao]

So I'm working this job where I need to keep track of my hours. I have rows of 4 columns. A is just the date and other random task info. B is the starting time, C is the ending time and D should be how many hours I worked on that particular day. The only problem is, I can't for the life of me figure out how to get Numbers to add up my hours automatically!! The SUM function just gives me the red triangle of WTF.

It's probably something really simple but this is my first attempt at spreadsheeting so easy on me all the Nick Burns out there

 

[Xapphire13]

Write your times in 24 hour format and an extra column for minutes
so have:
B as starting hr
C as starting min
D as end hr
E as end min
F as work time with the formula =(D1+(E1/60))-(B1+(C1/60))


OR set the format as time
then have work time as end time minus start time
for total work time have a box doing the SUM of all work time boxes
works in excel at least

If you want an example I can make one and post

 

[Mavimao]

Ah! OK, got it! Thank you very much!

 

[Xapphire13]

Not a problem