You can use a macro to just enter the time without the date

Sub testme()
With ActiveCell
.Value = Time
.NumberFormat = "h:mm:ss"
End With
End Sub




--
Regards,

Peo Sjoblom

(No private emails please)


"canix" wrote in
message ...

I already got it figure it out. I am using a macro button to enter the
now time on the cell and have another cell convert it to text so it
would leave out the date. That way the finished time will calculate
correctly the the text cell.

I know it will need a hidden column for the converted Text time. Thank
you all, I was hoping there's some easier way without using an extra
hidden column since my workbook is getting bigger and kinda running
slow.


--
canix
------------------------------------------------------------------------
canix's Profile:
http://www.excelforum.com/member.php...o&userid=25962
View this thread: http://www.excelforum.com/showthread...hreadid=393333