Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculating difference between two times
I have a spreadsheet with two columns that contain times (not dates, just times) in military time format. I want to make a third column that contains the hours and minutes between the two times. The first time is on a given day, and the next time is always on the next day. Some examples (with what should be returned): Time 1 Time 2 Result 10:45 11:45 25:00 13:00 11:45 22:45 11:00 10:00 23:00 I know Excel can't display times greater than 23:59, so I have been trying to use a formula to determine the hour, including a &":"&, and then a formula for the minutes. Anyone have any ideas? I keep getting close but then some instance throws me! -- Jaycatt ------------------------------------------------------------------------ Jaycatt's Profile: http://www.excelforum.com/member.php...o&userid=14633 View this thread: http://www.excelforum.com/showthread...hreadid=569565 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculating difference between two times
Hi!
Try this: Format the result cells as [h]:mm 1+B2-A2 Biff "Jaycatt" wrote in message ... I have a spreadsheet with two columns that contain times (not dates, just times) in military time format. I want to make a third column that contains the hours and minutes between the two times. The first time is on a given day, and the next time is always on the next day. Some examples (with what should be returned): Time 1 Time 2 Result 10:45 11:45 25:00 13:00 11:45 22:45 11:00 10:00 23:00 I know Excel can't display times greater than 23:59, so I have been trying to use a formula to determine the hour, including a &":"&, and then a formula for the minutes. Anyone have any ideas? I keep getting close but then some instance throws me! -- Jaycatt ------------------------------------------------------------------------ Jaycatt's Profile: http://www.excelforum.com/member.php...o&userid=14633 View this thread: http://www.excelforum.com/showthread...hreadid=569565 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculating difference between two times
Ooops!
1+B2-A2 That should be: =1+B2-A2 Biff "Biff" wrote in message ... Hi! Try this: Format the result cells as [h]:mm 1+B2-A2 Biff "Jaycatt" wrote in message ... I have a spreadsheet with two columns that contain times (not dates, just times) in military time format. I want to make a third column that contains the hours and minutes between the two times. The first time is on a given day, and the next time is always on the next day. Some examples (with what should be returned): Time 1 Time 2 Result 10:45 11:45 25:00 13:00 11:45 22:45 11:00 10:00 23:00 I know Excel can't display times greater than 23:59, so I have been trying to use a formula to determine the hour, including a &":"&, and then a formula for the minutes. Anyone have any ideas? I keep getting close but then some instance throws me! -- Jaycatt ------------------------------------------------------------------------ Jaycatt's Profile: http://www.excelforum.com/member.php...o&userid=14633 View this thread: http://www.excelforum.com/showthread...hreadid=569565 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculate the difference between two times | Excel Worksheet Functions | |||
Difference in dates calculations except between certain times. | Excel Discussion (Misc queries) | |||
Calculating Time difference based on a condition | Excel Discussion (Misc queries) | |||
Difference in Times | Excel Discussion (Misc queries) | |||
Calculating the difference between cells | Excel Worksheet Functions |