| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
TIME function
I am trying to create a spreadsheet with calculations for the various
times zones based on GMT. I use the function TIME(H,M,S). For example, to caculate a time in the US EST zone, I entered the formula E24-TIME(5,0,0), where E24 is 12:00 AM, representing UK time (GMT 0). The result comes out -5:00 AM. The correct result would be 5:00 PM. Oh yes, I am using Excel 2004 on an iBook with Mac OS X. (I get the correct result using this formula in Excel 2003 for Windows XP,) Thanks for your help! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel Time Manipulation | Excel Discussion (Misc queries) | |||
| Time Sheets | New Users to Excel | |||
| A Function for Counting Since Last Time | Excel Worksheet Functions | |||
| clock | Excel Worksheet Functions | |||
| What function do I use to convert "time" to minutes? | Excel Worksheet Functions | |||
Threaded Mode
