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 |
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 |
All times are GMT +1. The time now is 04:43 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com