Convert figures to Hours and minutes

[Finance Guru]

Hi All,

Using Excel 2007.
I have the following data
A B C D E F G
45 30 38 75 14 202 3.22

My problem is how to get F which is 202 minutes ( a total of A thro' E ) to
convert into G which is 3 hrs 22min ( which I show here only to illustrate
what I want to achieve ).

It all sounds so simple,but I cannot achieve this. Can some one give me the
formula to put in G to achieve the conversion.

Many thanks in advance

 

[Mike H]

Hi,

You don't need the intermediate sum cell, do it all in one

=SUM(A1:E1)/1440

Format as [hh]:mm

Mike

 

[Mike H]

Hi,

You don't need the intermediate sum cell, do it all in one

=SUM(A1:E1)/1440

Format as [hh]:mm

Mike

 

[Finance Guru]

Hi Gary's Studen & MikeH,

I tried both your answers and both solutions work fine.
Thank you both for taking the time out to reply

I told you it was Simple - just me having a bad day

Regards
Jack
--
Wales - the land of fire breathing dragons and rugby playing wizards.

Hi,

You don't need the intermediate sum cell, do it all in one

=SUM(A1:E1)/1440

Format as [hh]:mm

Mike

Hi All,

Using Excel 2007.
I have the following data
A B C D E F G
45 30 38 75 14 202 3.22

My problem is how to get F which is 202 minutes ( a total of A thro' E ) to
convert into G which is 3 hrs 22min ( which I show here only to illustrate
what I want to achieve ).

It all sounds so simple,but I cannot achieve this. Can some one give me the
formula to put in G to achieve the conversion.

Many thanks in advance

 

[Finance Guru]

Hi Gary's Studen & MikeH,

I tried both your answers and both solutions work fine.
Thank you both for taking the time out to reply

I told you it was Simple - just me having a bad day

Regards
Jack
--
Wales - the land of fire breathing dragons and rugby playing wizards.

Hi,

You don't need the intermediate sum cell, do it all in one

=SUM(A1:E1)/1440

Format as [hh]:mm

Mike

Hi All,

Using Excel 2007.
I have the following data
A B C D E F G
45 30 38 75 14 202 3.22

My problem is how to get F which is 202 minutes ( a total of A thro' E ) to
convert into G which is 3 hrs 22min ( which I show here only to illustrate
what I want to achieve ).

It all sounds so simple,but I cannot achieve this. Can some one give me the
formula to put in G to achieve the conversion.

Many thanks in advance

 

[Mike H]

Thanks for the fedback. No problem with the dragons but can we disagree about
Welsh rugby!!

Hi Gary's Studen & MikeH,

I tried both your answers and both solutions work fine.
Thank you both for taking the time out to reply

I told you it was Simple - just me having a bad day

Regards
Jack
--
Wales - the land of fire breathing dragons and rugby playing wizards.

Hi,

You don't need the intermediate sum cell, do it all in one

=SUM(A1:E1)/1440

Format as [hh]:mm

Mike

Hi All,

Using Excel 2007.
I have the following data
A B C D E F G
45 30 38 75 14 202 3.22

My problem is how to get F which is 202 minutes ( a total of A thro' E ) to
convert into G which is 3 hrs 22min ( which I show here only to illustrate
what I want to achieve ).

It all sounds so simple,but I cannot achieve this. Can some one give me the
formula to put in G to achieve the conversion.

Many thanks in advance

 

[Mike H]

Thanks for the fedback. No problem with the dragons but can we disagree about
Welsh rugby!!

Hi Gary's Studen & MikeH,

I tried both your answers and both solutions work fine.
Thank you both for taking the time out to reply

I told you it was Simple - just me having a bad day

Regards
Jack
--
Wales - the land of fire breathing dragons and rugby playing wizards.

Hi,

You don't need the intermediate sum cell, do it all in one

=SUM(A1:E1)/1440

Format as [hh]:mm

Mike

Hi All,

Using Excel 2007.
I have the following data
A B C D E F G
45 30 38 75 14 202 3.22

My problem is how to get F which is 202 minutes ( a total of A thro' E ) to
convert into G which is 3 hrs 22min ( which I show here only to illustrate
what I want to achieve ).

It all sounds so simple,but I cannot achieve this. Can some one give me the
formula to put in G to achieve the conversion.

Many thanks in advance

 

[Finance Guru]

Well okay - let's just say this year was a bad year for boyo's
--
Wales - the land of fire breathing dragons and rugby playing wizards.

Thanks for the fedback. No problem with the dragons but can we disagree about
Welsh rugby!!

Hi Gary's Studen & MikeH,

I tried both your answers and both solutions work fine.
Thank you both for taking the time out to reply

I told you it was Simple - just me having a bad day

Regards
Jack
--
Wales - the land of fire breathing dragons and rugby playing wizards.

Hi,

You don't need the intermediate sum cell, do it all in one

=SUM(A1:E1)/1440

Format as [hh]:mm

Mike

:

Hi All,

Using Excel 2007.
I have the following data
A B C D E F G
45 30 38 75 14 202 3.22

My problem is how to get F which is 202 minutes ( a total of A thro' E ) to
convert into G which is 3 hrs 22min ( which I show here only to illustrate
what I want to achieve ).

It all sounds so simple,but I cannot achieve this. Can some one give me the
formula to put in G to achieve the conversion.

Many thanks in advance

 

[Finance Guru]

Well okay - let's just say this year was a bad year for boyo's
--
Wales - the land of fire breathing dragons and rugby playing wizards.

Thanks for the fedback. No problem with the dragons but can we disagree about
Welsh rugby!!

Hi Gary's Studen & MikeH,

I tried both your answers and both solutions work fine.
Thank you both for taking the time out to reply

I told you it was Simple - just me having a bad day

Regards
Jack
--
Wales - the land of fire breathing dragons and rugby playing wizards.

Hi,

You don't need the intermediate sum cell, do it all in one

=SUM(A1:E1)/1440

Format as [hh]:mm

Mike

:

Hi All,

Using Excel 2007.
I have the following data
A B C D E F G
45 30 38 75 14 202 3.22

My problem is how to get F which is 202 minutes ( a total of A thro' E ) to
convert into G which is 3 hrs 22min ( which I show here only to illustrate
what I want to achieve ).

It all sounds so simple,but I cannot achieve this. Can some one give me the
formula to put in G to achieve the conversion.

Many thanks in advance