Calculating difference between two times

[Jaycatt]

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!

[Biff]

Hi!

Try this:

Format the result cells as [h]:mm

1+B2-A2

Biff

"Jaycatt" <Jaycatt.2c8ih5_1155062744.2794@excelforum-nospam.com> wrote in
message news:Jaycatt.2c8ih5_1155062744.2794@excelforum-nospam.com...
>
> 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
>

[Biff]

Ooops!

> 1+B2-A2

That should be:

=1+B2-A2

Biff

"Biff" <biffinpitt@comcast.net> wrote in message
news:%23kRpdxxuGHA.4756@TK2MSFTNGP04.phx.gbl...
> Hi!
>
> Try this:
>
> Format the result cells as [h]:mm
>
> 1+B2-A2
>
> Biff
>
> "Jaycatt" <Jaycatt.2c8ih5_1155062744.2794@excelforum-nospam.com> wrote in
> message news:Jaycatt.2c8ih5_1155062744.2794@excelforum-nospam.com...
>>
>> 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
>>
>
>