Format that as hh:mm

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"small tom" wrote
in message ...

Sorry, I obviously did not explain myself very well. I have already
subtracted the clock in time from clock out etc and that all works fine
but when I input my break time (eg, 0:45 for 45mins) it changes it to
12.45am and therefore I cannot subtract this from the total and get a
nice neat "hours worked" sum.

I need to know how to make 0:45 equate to 45mins rather than 12.45am.

Cheers

Tom


--
small tom
------------------------------------------------------------------------
small tom's Profile:
http://www.excelforum.com/member.php...o&userid=27828
View this thread: http://www.excelforum.com/showthread...hreadid=504413