Комментарии:
How to display in the msgbox the cell value contains time?
For example using vbcode: cells(1,1) .value= time
after the code, the cells(1,1) shows 4:54 PM because I discarded seconds by manual formatting the cell.
but then, in future use, I would like to use the value of cells(1,1) to display in msgbox.
but it shows 0.776666111 like that ,it shows decimal value.
I want it gives me the exact value on cells(1,1), the 4:54 PM.
Please help.