Hi there, I'm new here and I'm hoping someone can help. I'm creating a spreadsheet to record survey data in. It's airline stuff and I'm trying to be smart and calculate the difference between two times so I can say whether the flight took off early, was on time or was late. I've simply subtracted one cell from the other which, where the flight was on time is fine the formula chucks back 00:00 or where the flight was late it shows 00:42 but where it was early i've got loads of ######### because it won't show time as being a negative I think.
Anyone know how i can show it? I would then like to put a conditional colour format on showing early as green, on time as green and red as late.
Any help would be gratefully received. Thank you
Does anyone know how to get excel to create the numbers of days difference
between 2 dates and removing the weekends at the same time using a formula?
Need formula adapting or alternative to include variable business hours at weekend and exclude holidays that can also occur at weekend e.g. New Years Day.
Formula should also allow for variable business hours each day during week but are same week to week and exclude holidays.
The formula below does NOT allow for variable business hours that do occur.
=((NETWORKDAYS(StartTime,EndTime,HolidayList)-1)*(BusHrsEnd BusHrsStart)+IF(NETWORKDAYS(EndTime,EndTime,HolidayList),MEDIAN(MOD(EndTime,1), BusHrsEnd, BusHrsStart), BusHrsEnd)-MEDIAN(NETWORKDAYS(StartTime,StartTime,HolidayList)*MOD(StartTime,1), BusHrsEnd, BusHrsStart))))
Hi all,
I'm newbie here...
I have a problem I have one excel file with one sheet open. This sheet content a lot of hyperlink to another hidden sheet. FYI, this only one file excel.
My question,
is that possible to make difference access for difference people to click those hyperlink? I meant Person A only access hyperlink A, person B access hyperlink B, is that possible to do that? If yes, how....
Thx a lot
G
Hi Guys,
Does anyone know of a web site which offers Excel tips and tricks.
Is there a free book which I can download that will give me tips and tricks.
Thanking you in advance,
Regards
J-O
What is the easy way to create forms in different sheets.......
In Main Sheet (Sheet1) each row contains some informations about a particular item.
I want to create Forms in separate Sheets and datas for this Form 1 (Sheet2) should be datas of Row#1 of Sheet1 & datas for this Form 2 (Sheet2) should be datas of Row#2 of the Sheet1.......
Hello
I am wanting to calculate the difference in days between two dates i.e date work completed and date work began - however I only want to count the number of working days in this respect, is it possible to write a formula to do this?
Thank you in advance for your help
Terri
Hi,
I am using this formula to calculate the difference (in months) between two
dates;
=DATEDIF(A2,B2,"m")
However there is a problem. When using the above formula the difference
between these two dates-
1/4/2006 - 31/3/2006
The formual returns 11 months. This isn't correct as they are actually 364
days apart, and the difference I need to see for my purposes is 12 months.
Does anybody have a solution?
Many thanks
HI,
I want the user to be able to type times without the :
In A1 is custom formatted as: 00\:00 and when typing 1234 it displays 12:34
So far so good especially because I don't want to use helper/adjacent cells.
Cell B1 is formatted as hh:mm and has 13:15 in it.
I want to calculate the time difference between A2 and A1 (expected 00:41)
=B1-A1 in cell C1 (formatted as hh:mm) won't give the correct answer - so I tried:
=INT(B1/100)/24+MOD(B1,100)/1440-INT(A1/100)/24-MOD(A1,100)/1440
which is OK but I wonder if there is any shorter formula to calculate the difference ?
Thanks, Elm
Hi,
I have two dates with time in two cell. I need to calculate the difference between the two in only seconds. Tell me a function for that.
format of the date: 01/02/09 19:23:00
Thanks,
Cheers
