lks55
03-23-2016, 08:44 AM
Hi,
I need to copy cells with vba. One cell has the format with days, the other cell has only hours. Obviously when i compare them, the cell with days will be bigger. Is there a simple trick to cut away the days ?
I use this code:
If tsm(s3).depart < (tsm(s3).fixedtime + WorksheetFunction.RoundDown(tsm(s3).depart, 0)) Then
I managed to do this by adding the days, to the figure without. I would like to keep it more simple. If there is a possibility please let me know.
Thank you
I need to copy cells with vba. One cell has the format with days, the other cell has only hours. Obviously when i compare them, the cell with days will be bigger. Is there a simple trick to cut away the days ?
I use this code:
If tsm(s3).depart < (tsm(s3).fixedtime + WorksheetFunction.RoundDown(tsm(s3).depart, 0)) Then
I managed to do this by adding the days, to the figure without. I would like to keep it more simple. If there is a possibility please let me know.
Thank you