Time Formula Result Exceeds 24 Hours

  • Thread starter Thread starter Dale Howard
  • Start date Start date
D

Dale Howard

Folks --

In Excel, I am trying to add a column of numbers that are formatted "h:mm".
The numbers represent the number of hours worked in each time period, which
is usually less than a day. The total number of hours for all time periods
equals 28.00 hours, but the result of the Sum formula shows 4:00.

Is there a way to show the result of the Sum formula formatted with "h:mm"
and which will show the result as 28:00? As a newly nominated Microsoft
Project MVP (not yet approved), I can tell you by experience how helpful
these newsgroups are, so thanks in advance for your help!

--
Dale A. Howard
Enterprise Project Trainer/Consultant
Denver, Colorado
http://www.msprojectexperts.com
"We wrote the book on Project Server"
 
Folks --

In Excel, I am trying to add a column of numbers that are formatted "h:mm".
The numbers represent the number of hours worked in each time period, which
is usually less than a day. The total number of hours for all time periods
equals 28.00 hours, but the result of the Sum formula shows 4:00.

Is there a way to show the result of the Sum formula formatted with "h:mm"
and which will show the result as 28:00? As a newly nominated Microsoft
Project MVP (not yet approved), I can tell you by experience how helpful
these newsgroups are, so thanks in advance for your help!
Click to expand...


Format the result as [h]:mm


--ron
 
Robert and Ron --

Thanks loads for your help! I'll be you get asked a question like mine lots
of times. The answer is so simple and yet so elusive!

--
Dale A. Howard
Enterprise Project Trainer/Consultant
Denver, Colorado
http://www.msprojectexperts.com
"We wrote the book on Project Server"


Ron Rosenfeld said:
Folks --

In Excel, I am trying to add a column of numbers that are formatted "h:mm".
The numbers represent the number of hours worked in each time period, which
is usually less than a day. The total number of hours for all time periods
equals 28.00 hours, but the result of the Sum formula shows 4:00.

Is there a way to show the result of the Sum formula formatted with "h:mm"
and which will show the result as 28:00? As a newly nominated Microsoft
Project MVP (not yet approved), I can tell you by experience how helpful
these newsgroups are, so thanks in advance for your help!
Click to expand...


Format the result as [h]:mm


--ron
Click to expand...
 
Back
Top