| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro converts time entered in column E and F from Indian time to CST( without daylight saving)
Private Sub Worksheet_Change(ByVal Target As Range)
Application.EnableEvents = False On Error GoTo Error_out: Dim mrange As Range Set mrange = Range("E:F") If Not Intersect(Target, mrange) Is Nothing Then Target = Target - TimeValue("13:30") End If Application.EnableEvents = True 'MsgBox ("Check Day-Light-Saving") optional Exit Sub Error_out: Application.EnableEvents = True End Sub |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Tracking Time of different city in comparision to Indian Standared Time | Excel Programming | |||
| Tracking Time of different city in comparision to Indian Standared Time | Excel Programming | |||
| Daylight Saving Time (DST) and calculating time difference. | Excel Programming | |||
| Daylight Saving Time (DST) and calculating time difference. | Excel Programming | |||
| Time difference calculations, daylight savings time, Excel | Excel Discussion (Misc queries) | |||
Threaded Mode
