My better half has asked for my assistance in constructing a table that would reflect the time differences between locations in different parts of the world (based on military time). I’ve been able to partially accomplish this by making use of Excel’s “Time” function as indicated in the example below. When I add time to the (EST) the function performs quite well. However, when the function encounters negative numbers, (time zones that run behind ours) it runs into problems. Any assistance would be greatly appreciated.
Chuck
US
(EST)
TIME Difference
(in hours) Local
Time Function
22:00 6 4:00:00 AM =A2+TIME(B2,0,0)
15:00 -1 #NUM! =A3+TIME(B3,0,0)
I am trying to do a strange ways of adding, like if cell is a1=500, b1=500,
c1=500 then on cell f1 has column down to f5 with formula like first cell
f1=65, f2=100 on down to f5, then next roll over g1 to g5 has formula of
subtract of f1 from a1 which is 435, then g2 has f2 subtract from a1 then its
335, now ? is if g4 show 0 or -0 I want it to pick up b1 from a1 and keep on
subtracting till last cell is completed like g5 is last cell with out going
pass 0 or -20
I need help with adding and subtracting times. Our vacation is based on 1.54 hrs / week and I would like to keep track of this. How can I do this? When I take a 8.0 hr vacation day and then add back my 1.54 hrs received.
Good day...
How can I add or subtract 12h to a field that contains a time in hh:mm?
Thanks folks.
I was hoping you guys could help me.
I have this time sheet which keeps track and tells me how many hours it takes to do specific things. On the bottom i have buttons that my people push when they are stop on a cirtain project and when they start back up. Now when they have put in there stop time at the top of page it totals up the hours. I need the bottom colum to add or subtract the amount of time they were not on the panel.
When they are over in time the total hours is red. When they are under in time the total hours is green.
I hope i explained it well enough if there are any questions feel free to ask.
Please heeeelpnvagle@epgco.com
Hi,
Why am I not getting the right answer?! (the answer should be 4:30)
A1
8:10
B1
12:40
=B1-IF(A1
Is there a formula for this:
In B2 there is a value, such as 1,500,000
In B3 is where I want the sum and the formula
In A3 I would like to be able to enter a percentage such as 4% but I could change that percentage in B3 if needed and it would make the the change in the calculation. Say change to 5.5%
So then I could produce a sum total in B3 such as minus 4% of B2.,
(1,500,00) minus 4% is what would calculate in B3...
If this is possible I would like to have the same scenerio but using plus 4% instead of minus 4% in another formula and cells.
Thanks for any assistance.
Couple (probably really easy) things I would like to know actually.
1) To be able to get the current date in the format of 3/10/2008
2) To be able to take dates from 2 cells and get an integer value for the number of days between the two dates
Trying to make calculations with time. Have already switched workbook options to 1904 Date System. Trouble crossing over midnight.
5:45 PM 12:35 AM
Need to calculate 12:35 AM - 5:45 PM; a shift that crosses midnight. Answer should be 06:50. HELP PLEASE!!!!!
All I want to do is a simple addition and subtraction of hours.
For example
10 1/2 hours 4 days a week should add up to 42 hours
but it has to be in that format hours and min
10.30 + 10.30+10.30+10.30 = 42.
Cant figure out to do it.
then also in subtraction
40hours - 10.30 = 29.30 hours
anyhelp would be great
