xl_psychic
Active Member
- Joined
- Jan 4, 2004
- Messages
- 359
Hi All,
I was trying to convert time my local time (Indian Standard Time) to PST (Pacific Standard Time) in Excel.
Now I can do this by subtraction 13:30 hrs from my time.
However when I tried subtracting 13:30 hrs from 0:30, Excel gives me 13:00 hrs as an output whereas if it is calculated manually the output should be 11:00 hrs.
If I subtract 13:30 hrs from 24:30, Excel gives me the exact value of 11:00 hrs.
Find attached the HTML Screenshot of the same...
Can someone let me know the reason and a turnaround for such calculation..
Help Appreciated..
I was trying to convert time my local time (Indian Standard Time) to PST (Pacific Standard Time) in Excel.
Now I can do this by subtraction 13:30 hrs from my time.
However when I tried subtracting 13:30 hrs from 0:30, Excel gives me 13:00 hrs as an output whereas if it is calculated manually the output should be 11:00 hrs.
If I subtract 13:30 hrs from 24:30, Excel gives me the exact value of 11:00 hrs.
Find attached the HTML Screenshot of the same...
Can someone let me know the reason and a turnaround for such calculation..
Help Appreciated..