TIME IN to TIME OUT = HOURS formula on Numbers 09 - PLEASE HELP!
Hi,
I've just got Numbers '09 and I have a question about formulas.
I want to have column A (time in - eg. 1PM), then column B (time out eg. - 3PM) and column C (number of hours worked, calculated automatically).
I have figured out how to get Numbers 09 to calculate the number of hours (C = B-A) BUT... when I put in TIME OUT hours that are past midnight (eg. 00:30 AM) the whole thing goes haywire!
Can anyone out there provide me with a simple solution for columns A, B and C that can deal with a 24 hour clock and a shift that goes past midnight?
All I need it to do is calculate the number of hours worked in column C, after inputting the start time in column A, and the finish time in column B.
Thanks!!
D
New Aluminium Macbook, Mac OS X (10.5.5)