Re: Time formulas

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Thanks again.

"Peo Sjoblom" wrote:

If you are going to use decimal values you need to format the result as
General or number, not time


--


Regards,


Peo Sjoblom



"Blazingsaddles" <Blazingsaddles@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:DD3AD86C-BAD3-4A01-AAAF-BD6D10AD1BFE@xxxxxxxxxxxxxxxx
Ugh! What am I doing wrong? C10 is 12:00 am with this formula.

Thanks.

"T. Valko" wrote:

Try this:

=(MOD(C7-C6,1)+MOD(C9-C8,1))*24

--
Biff
Microsoft Excel MVP


"Blazingsaddles" <Blazingsaddles@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
message
news:3FDB682F-9C8E-405E-9AC4-BCB29C2C1128@xxxxxxxxxxxxxxxx
Here is my time***:

c6: 11:00 pm
c7: 12:00 am
c8: 7:00 am
c9: 3:00 pm
c10: (Actual hours worked)

If I use the formula: =IF(C6>C7,C7+1-C6,C7-C6)*24
I can get the time for c6/c7, but what formula do I use to not only get
the
hours from c6/c7, but also from c8/c9 - to get the total of 9 hours in
c10?

Thanks, I appreciate any help.






.

Quantcast