How do I process hours greater than 24
in [General]
|
From: dixr on 22 Feb 2010 12:05 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 22 Feb 2010 12:12 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 22 Feb 2010 12:18 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
|
Pages: 1 Prev: How retreive specific data from 1st Sheet and placing it on 2nd Sh Next: Puzzling attribute |