Hi!

Make it easy on yourself and use 2 cells. It'll also be less of a headache
to enter the times as times:

A1 = 7:00 AM
B1 = 3:00 PM

=(B1-A1+(B1<A1))*24

Biff

"chefcasey" wrote
in message ...

I'm working on a work schedule. I would like to put two numbers that
represent time in a single cell and have them caculated to total the
amount of hours worked.

example:

7-3


--
chefcasey
------------------------------------------------------------------------
chefcasey's Profile:
http://www.excelforum.com/member.php...o&userid=27198
View this thread: http://www.excelforum.com/showthread...hreadid=467241