quartz, 12:00 pm - 7:30 am x 24, format cell as general, like this
=(B1-A1)*24
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"quartz" wrote in message
...
I'm blanking on this:

Take 7:30 AM and subtract 12:00 PM to get hours worked...
How can I put that in a formula and have it return 4.5?

TIA