Great idea, but the nurse will be entering this data at the end of the day so
a time stamp won't work.

Cyrus

"CLR" wrote:

How about just having the Nurse select the cell where the entry is supposed
to go and then hitting a Button to run this macro..........

Sub TimeStamp()
' Select a cell and run the macro to insert
' the current date and time
ActiveCell.FormulaR1C1 = Date & " " & Time
End Sub

It will automatically enter a perfect current Date and Time Stamp

Vaya con Dios,
Chuck, CABGx3


"Cyrus" wrote:

I have a log sheet where a nurse will enter the time in and time out. I have
a formula giving the total time in clinic. What is the best way to set up
formatting for entry?

I don't want the nurse to be required to type a colon, but I do need her to
do AM or PM.

My formula for figuring the time duration is:

=TEXT(IF(M2-L20,M2-L2,""),"h:mm")

Is this the best formula for ease of entry?

I would like her to type time in to be "130p" and time out "215p" and my
formula to display "00:45" I need am/pm so that it can figure time in
"1245a" and time out "115p"

I need help!!!

Cyrus