Go to the Format menu, choose Cells, then the Number tab. In the
Category list, choose Custom and enter [h]:mm in the Type text
box.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"Harley mom" <Harleymom@discussions.microsoft.com> wrote in
message
news:E6703973-33F4-4879-B599-BD6FDAE0D380@microsoft.com...
>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
>> >
>>
>>
>>