P
Paul
Adding time in my worksheet and I am having a hard time when it comes over 24hr. I have tried custom with no luck
Any answers?
Any answers?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
P
Peo Sjoblom
Use custom format [hh]:mm
--
Regards,
Peo Sjoblom
--
Regards,
Peo Sjoblom
24hr. I have tried custom with no luck.Paul said:Adding time in my worksheet and I am having a hard time when it comes over
P
Paul
The hours add up to the hundreds.
P
Peo Sjoblom
Did I say something in my reply that was opposite to hundreds of hours? At
least have the courtesy to try out a suggestion,
AFAIK custom format [hh]:mm works for thousands of hours
least have the courtesy to try out a suggestion,
AFAIK custom format [hh]:mm works for thousands of hours
B
Bob Phillips
Peo,
The OP probably thought that as there were only 2 h it would only cover 99
hours.
--
HTH
Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
The OP probably thought that as there were only 2 h it would only cover 99
hours.
--
HTH
Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
Peo Sjoblom said:Did I say something in my reply that was opposite to hundreds of hours? At
least have the courtesy to try out a suggestion,
AFAIK custom format [hh]:mm works for thousands of hours
--
Regards,
Peo Sjoblom
Paul said:The hours add up to the hundreds.
P
Peo Sjoblom
<bg>
--
Regards,
Peo Sjoblom
--
Regards,
Peo Sjoblom
Bob Phillips said:Peo,
The OP probably thought that as there were only 2 h it would only cover 99
hours.
--
HTH
Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
Peo Sjoblom said:Did I say something in my reply that was opposite to hundreds of hours? At
least have the courtesy to try out a suggestion,
AFAIK custom format [hh]:mm works for thousands of hours
--
Regards,
Peo Sjoblom
Paul said:The hours add up to the hundreds.
P
Paul
Sorry Peo, about not trying it first
I did put it in as [hh]:mm
The column sum for the cel was ####
I am using for a formula sum=(e4:e34)
I did put it in as [hh]:mm
The column sum for the cel was ####
I am using for a formula sum=(e4:e34)
P
Peo Sjoblom
Check to see if column size is too small, only reason you would get ###
otherwise would be if the
time was negative, just pull the right hand column border to the right and
it should come out alright
otherwise would be if the
time was negative, just pull the right hand column border to the right and
it should come out alright
P
Paul
That made the ### sign go away but the answer was wrong. 2412.00 it should have been 100:30 hrs
P
Paul
Thank you Peo Sjoblom.
You made it work
You made it work
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.