Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Hi guys... I have a similiar query.... plzzzz can someone help me!
I'm constructing a spreadsheet to work out the difference in time and date; A1 A2 A3 07/11/04 11:00 04/11/04 10:00 3:1:00 (d:h:mm) but now i'm trying to work out a fomula that if it goes over one day the formula would work out true/false... i've tried doing the following but it doesn't work; =IF(A3=1,"Failed","Met") but it doesn't work...... doesn't seem to register the day Thank you |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I set up a formula on a time sheet to calculate time in 1/. | Excel Discussion (Misc queries) | |||
calculate negative or positve difference in time | Excel Discussion (Misc queries) | |||
How do you calculate the difference between two values within a p. | Excel Discussion (Misc queries) | |||
What is the formula for getting time difference e.g. ("4 hrs 15 m. | Charts and Charting in Excel | |||
Time / Formula to look at time difference | Excel Worksheet Functions |