Hi, all
[VBA]Sheet2.Cells(I, 17).Value = Format(Sheet2.Cells(I, 8), "00:00").Value - Format(Sheet2.Cells(I, 7), "00:00").Value[/VBA]
Its Error
pls help me how should i change ?
Hi, all
[VBA]Sheet2.Cells(I, 17).Value = Format(Sheet2.Cells(I, 8), "00:00").Value - Format(Sheet2.Cells(I, 7), "00:00").Value[/VBA]
Its Error
pls help me how should i change ?
without knowing what you are refering to we cant really help!, what is the error? have you got your cells address correct i.e Cells(RowIndex, ColumnIndex)
Regards,
Simon
Please read this before cross posting!
In the unlikely event you didn't get your answer here try Microsoft Office Discussion @ The Code Cage
If I have seen further it is by standing on the shoulders of giants.
Isaac Newton, Letter to Robert Hooke, February 5, 1675 English mathematician & physicist (1642 - 1727)
i'm really sorry the unclear message, correct the col G & H value are number format that actually is time,Originally Posted by Simon Lloyd
want to calculating the different time by col H - G and for convert to 00:00
don't know it ok or not as i try built a macros for my worksheet.
Have you just tried[VBA]Sheet2.Cells(I, 17).Value = Sheet2.Cells(I, 8).Value - Format(Sheet2.Cells(I, 7).Value[/VBA]
Regards,
Simon
Please read this before cross posting!
In the unlikely event you didn't get your answer here try Microsoft Office Discussion @ The Code Cage
If I have seen further it is by standing on the shoulders of giants.
Isaac Newton, Letter to Robert Hooke, February 5, 1675 English mathematician & physicist (1642 - 1727)