From: dixr on
Doing a timesheet application, how to I add up the hours when they exceed 24
hours? The same issue would come up in a project management application when
the project will exceed 24 hours. I need to have hours up to thousands. The
applications need to keep fractional hours in minutes - hhhh:mm
From: Fred Smith on
Use a format like:
[h]:mm

Regards,
Fred

"dixr" <dixr(a)discussions.microsoft.com> wrote in message
news:5EF4BF0B-BCB4-4CBC-A8F6-4C97CDDBCE7C(a)microsoft.com...
> Doing a timesheet application, how to I add up the hours when they exceed
> 24
> hours? The same issue would come up in a project management application
> when
> the project will exceed 24 hours. I need to have hours up to thousands.
> The
> applications need to keep fractional hours in minutes - hhhh:mm

From: Gary''s Student on
Format the cells as [hhhhhh]:mm:ss
--
Gary''s Student - gsnu201001


"dixr" wrote:

> Doing a timesheet application, how to I add up the hours when they exceed 24
> hours? The same issue would come up in a project management application when
> the project will exceed 24 hours. I need to have hours up to thousands. The
> applications need to keep fractional hours in minutes - hhhh:mm