Time format help

[Dave]

Hi all,
I have a spreadsheet (Excel 2002), and column H contains the formula
=MINUTE(F6-E6) to generate a time period from start and finish. in Cell
H78, I have the formula =SUM(H3:H37) to add these times, to give a total
of minutes.

I want to display the total in H38 in Hours and Minutes i.e. 03:30, but
it doesn't appear obvious to me how to achieve this - Could someone give
me a clue please?

TIA

 

[Peo Sjoblom]

Why use the minute at all? Use format to hide the seconds hh:mm
Just subtract start from end

=F6:E6

then sum and use

[hh]:mm

as format

If not (note that if the time is more than an hour [minute] will be
incorrect)
use a formula like

=SUM(H3:H37)/1440

use the same format [hh]:mm

 

[Bob Phillips]

Dave,

If I understand you want

=SUM(HB3:H37)/24/60

and format as [h]:mm

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Dave]

Hi all,
I have a spreadsheet (Excel 2002), and column H contains the formula
=MINUTE(F6-E6) to generate a time period from start and finish. in Cell
H78, I have the formula =SUM(H3:H37) to add these times, to give a total
of minutes.

I want to display the total in H38 in Hours and Minutes i.e. 03:30, but
it doesn't appear obvious to me how to achieve this - Could someone give
me a clue please?

TIA

Thanks for the help - I feel a bit silly now