Canix wrote:
But that would be too much for user who had to enter the date and time
altogether. Is there anyway that can perform automatically where user
only need to enter the time.

Time and date entry can be done more quickly using the shortcuts:
Date: CTRL-;
Time: CTRL-SHIFT-;

So to enter the date and time, just use:
<CTRL-;<space<CTRL-SHIFT-;

Note: this only works if you want the current date and/or time to be
entered.

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

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