Time to convert to India time

Hi,

Time to convert to India time

General work hours as 9 AM - 6:30 PM

Column "C" has other country names. When its 9.00 AM to 6.30 PM shift in India whats the time in those countries. Is there any easy way to capture this. As i have huge content to be converted. Any script that can do this.

thanks
Attached file
time.xls
LVL 11
bsharathAsked:
Who is Participating?
 
Robberbaron (robr)Commented:
creating the indian time into your table is easy enough, though the links mlmcc pointed to show the problems with day as well. Though not such a problem for your location.


what 'content' do you need converted ?  Are you after a lookup table or a script to modify data ?
Option Explicit

Function MakeIndiaTime(offsethours As Integer) As String


    Dim indiastart As Date, indiaend As Date
    Dim localstart As Date, localend As Date
    
    indiastart = TimeSerial(9, 0, 0)  '0900 am
    indiaend = TimeSerial(18, 30, 0)  '1830 = 6.30pm
    
    localstart = indiastart + TimeSerial(offsethours, 0, 0)
    localend = indiaend + TimeSerial(offsethours, 0, 0)
    
    MakeIndiaTime = Format(localstart, "HH:nn") + " - " + Format(localend, "HH:nn")
End Function

Open in new window

india-time.xls
0
 
mlmccCommented:
Check this link.  It has a sme spredsheet

http://www.mrexcel.com/forum/showthread.php?t=300163

mlmcc
0
 
bsharathAuthor Commented:
A little confused with the output
When its 9 AM to 6. 30 PM in india
Should't  SanJose be 7.30 AM 4.30 PM
But now we get as 01:00 - 10:30

can you please help fix this
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
mlmccCommented:
What San Jose are you referring to?
If it is the one in California (US) it should be 7:30PM (previous day) - 5:00AM
India - GMT+5:30
San Jose California (US) GMT - 8:00

So India to San Jose California (US) is India - 13.5

mlmcc
0
 
bsharathAuthor Commented:
ya its the san Jose you are referring

When its 9.00 AM in India whats the time in San Jose?

is the excel out right?

0
 
mlmccCommented:
How is the Offset parameter set?

Need to subtract 5:30 from it.

mlmcc
0
 
mlmccCommented:
If the India Time is India local you have to account for the India differnece with GMT.  The offsets in the spreadsheet are off GMT.

See attached spreadsheet

mlmcc
india-time-R1.xls
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.