View Full Version : Error ,want help
KK1966
05-31-2013, 07:12 PM
Hi, all
Sheet2.Cells(I, 17).Value = Format(Sheet2.Cells(I, 8), "00:00").Value - Format(Sheet2.Cells(I, 7), "00:00").Value
Its Error
pls help me how should i change ?
:bow:
Simon Lloyd
05-31-2013, 08:22 PM
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)
KK1966
05-31-2013, 08:26 PM
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)
i'm really sorry the unclear message, correct the col G & H value are number format that actually is time,
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.
Simon Lloyd
05-31-2013, 08:32 PM
Have you just tried
Sheet2.Cells(I, 17).Value = Sheet2.Cells(I, 8).Value - Format(Sheet2.Cells(I, 7).Value
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.