| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Subtracting Hours
Hi,
I want to convert Israel time to U.S time. Every thing is going fine until the number become negative. For example: if the time in Israel is 02:30 and I want to find what is the time at New York I have to subtract 7:00 hours, and I Excel don't calculate it. Any help? Thanks, Amnon |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Subtracting Hours
if A1 = 02:30 and B1 = 07:00
then you can use: =MOD(A1-B1+"24:00","24:00") to get 19:30 "Amnon Wilensky" wrote in message ... Hi, I want to convert Israel time to U.S time. Every thing is going fine until the number become negative. For example: if the time in Israel is 02:30 and I want to find what is the time at New York I have to subtract 7:00 hours, and I Excel don't calculate it. Any help? Thanks, Amnon |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Subtracting Hours
Just use
=MOD(start_time-hours/24,1) "Amnon Wilensky" wrote in message ... Hi, I want to convert Israel time to U.S time. Every thing is going fine until the number become negative. For example: if the time in Israel is 02:30 and I want to find what is the time at New York I have to subtract 7:00 hours, and I Excel don't calculate it. Any help? Thanks, Amnon |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Subtracting Hours
Try this
=A1-7/24+1 Format cell as hh:mm "Amnon Wilensky" wrote: Hi, I want to convert Israel time to U.S time. Every thing is going fine until the number become negative. For example: if the time in Israel is 02:30 and I want to find what is the time at New York I have to subtract 7:00 hours, and I Excel don't calculate it. Any help? Thanks, Amnon |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| get hours between 2 dates subtracting the weekends | Excel Discussion (Misc queries) | |||
| Subtracting Hours - Eastern to Pacific/Central | Excel Worksheet Functions | |||
| adding rows of hours and minutes to get a total | Excel Worksheet Functions | |||
| Subtracting dates to get hours... but I want to skip weekends | Excel Discussion (Misc queries) | |||
| Subtracting paid hours from unpaid hours | Excel Worksheet Functions | |||
Linear Mode
