Posted to microsoft.public.excel.misc

hsg

external usenet poster

Posts: 40

display time in IST as well as GMT?

I need to display time in two cells in different format

a1 = indian standard time
b1=corresponding GMT

example: a1=06:00 then b1=00:30 (IST = +5:30 GMT)
a1=02:00 then b1=20:30

Is there a formula which will do the trick?

Furthermore, I want to enter IST in cell A1 by simply entering 0600 or 0200,
can this be automatically
formatted to display 06:00 or 02:00?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Enter time with . but display as :	harwookf	Excel Discussion (Misc queries)	11	October 10th 08 08:03 PM
Display Elapsed Time	Nigel	Excel Worksheet Functions	2	May 29th 07 02:23 PM
Time display	grahammal	Excel Discussion (Misc queries)	1	May 15th 06 11:40 AM
Time Display ?	Bob Newman	Excel Worksheet Functions	3	February 2nd 06 03:20 AM
Display one row at a time	Sirvincent	New Users to Excel	2	March 21st 05 02:26 AM

All times are GMT +1. The time now is 12:47 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us