Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to calculate the difference between two different times.
How to tell the time?
I have an Excel 2007 workbook that I require to be able to €˜countdown the time remaining until the scheduled start time of a market event. I require that the function returns a value dependent upon the amount of time remaining. Time Cell Return Start Time - 10+ Minutes A Start Time - 5 to 10 Minutes B Start Time - 2 to 5 Minutes C Start Time - Under 2 Minutes D I require assistance with both the formula to use and any relevant information regarding the cell format / data type for cells B3 and B4 in the example below The time format I have used is HH:MM:SS In the example below the time remaining is calculated as 7 minutes & 25 seconds, I need to know how to calculate this time difference and how to convert that into seconds (445 Seconds) for use in the Vlookup function (D1..E4) to return the letter B A B C D E 1 Current Time: 13:52:35 600 A 2 Sheduled Start: 14:00:00 300 B 3 Time Remaining: 00:07:25 120 C 4 Return: B 0 D Many thanks for your help |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to calculate the difference between two different times.
Time remaining:
=(B2-B1)*86400 [86400 = 60 seconds * 60 minutes * 24 hr, thus giving you seconds as an integer] You should format the cell as number probably You need to swith the order of your table to go from 0 to 600 for lookup functions to work. Return formula: =LOOKUP(B3,D1:E4) -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Highbury 1" wrote: How to tell the time? I have an Excel 2007 workbook that I require to be able to €˜countdown the time remaining until the scheduled start time of a market event. I require that the function returns a value dependent upon the amount of time remaining. Time Cell Return Start Time - 10+ Minutes A Start Time - 5 to 10 Minutes B Start Time - 2 to 5 Minutes C Start Time - Under 2 Minutes D I require assistance with both the formula to use and any relevant information regarding the cell format / data type for cells B3 and B4 in the example below The time format I have used is HH:MM:SS In the example below the time remaining is calculated as 7 minutes & 25 seconds, I need to know how to calculate this time difference and how to convert that into seconds (445 Seconds) for use in the Vlookup function (D1..E4) to return the letter B A B C D E 1 Current Time: 13:52:35 600 A 2 Sheduled Start: 14:00:00 300 B 3 Time Remaining: 00:07:25 120 C 4 Return: B 0 D Many thanks for your help |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculate difference in Times | Excel Discussion (Misc queries) | |||
calculate difference between two times | Excel Worksheet Functions | |||
Calculate the difference between two times | Excel Worksheet Functions | |||
Calculate the difference between two times | Excel Worksheet Functions | |||
Calculate the difference two times | Excel Discussion (Misc queries) |