Hiyou will probably need VBA - if you dont want a formula to be in the cell
it can still be blank with and
=IF(A2="","", D2-Timevalue(whatever india time is )
and then copy down 1000 + cells - it will just show blank for empty cells
OR use a table and the formula will be autofilled when a new row is added
But will the timezone always be Sydney times - or will this change
how do you work out time zones
what version of Excel are you using ?
i have entered the formual but i get the output in this formatyou will probably need VBA - if you dont want a formula to be in the cell
it can still be blank with and
=IF(A2="","", D2-Timevalue(whatever india time is )
and then copy down 1000 + cells - it will just show blank for empty cells
OR use a table and the formula will be autofilled when a new row is added
But will the timezone always be Sydney times - or will this change
how do you work out time zones
what version of Excel are you using ?
time