I only have [h]:mm:ss. is there a way to elimenate the seconds.

"Tom Ogilvy" wrote:

> the format should be
>
> [h]:mm
>
> at least in a US English version.
>
> --
> Regards,
> Tom Ogilvy
>
> "Harley mom" <Harleymom@discussions.microsoft.com> wrote in message
> news:6896A5AF-210C-4711-A9B7-BCCD5D3CDC60@microsoft.com...
> > I have done a time sheet in excell. the columns are Employee name, Time
> in,
> > Time out, Total Hours,- 30 Minute lunch,total hours worked for the day. I
> am
> > now trying to total the number of hours worked for this employee for the
> > week. I did auto sum but the number will not go past 24. How can i get
> this
> > total for the week. I have the cell formatted as follows
> > Format>cells>Number>Custom{h}:mm . Here is what my colmun looks like. i
> > should have a total of 48:50 what am i doing wrong
> >
> >
> > 10:30
> > 0:00
> > 10:15
> > 0:00
> > 0:00
> > 10:00
> > 9:00
> > 8:00
> > 23:45
> >
>
>
>