Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
periods of time
Hi
Can somebody help me with this please,i need a formular that can calculate the difference between the two times and show the answer as a plus or minus or green/red.For example in the below, the answer would be +1:30 as the actual time is an 1hr 30min before the expected. Expected arrival time 8:00 Actual arrival time 6:30 answer Thanks Ben |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
periods of time
Hello again Ben, You need the following formula in column D: =(B1-A1)*24 You will need to format the result cells to be General formats not dates. To do the highlight all the expected results cells for column D and hold Ctrl + Shift and press #. This will set the cells to General formatting. If you also want different colours you will also need Conditional Formatting: Highlight the results cells in column D and choose Format + Conditional Formatting. Change the Between text to Greater than 0 and click the Format button - choose grenn. Click the Add button. Change the Between text to Less than 0 and choose the second Format button - choose Green. Post again with any problems Judith -- JudithJubilee ------------------------------------------------------------------------ JudithJubilee's Profile: http://www.excelforum.com/member.php...fo&userid=6882 View this thread: http://www.excelforum.com/showthread...hreadid=519160 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Time sheets | Excel Worksheet Functions | |||
Formula for a time card | Excel Worksheet Functions | |||
time sheet to calculate 2 different columns | Excel Worksheet Functions | |||
Adding time | Excel Discussion (Misc queries) | |||
Time Sheet Calculation Help Needed! | Excel Worksheet Functions |