Re: Time formulas

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: "T. Valko" <biffinpitt@xxxxxxxxxxx>
Date: Tue, 9 Oct 2007 17:51:05 -0400

You're welcome!

--
Biff
Microsoft Excel MVP

"Blazingsaddles" <Blazingsaddles@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:619FF54C-205F-42B9-9A6C-2EA5E5A22A5C@xxxxxxxxxxxxxxxx

Thanks for your help, I got it fixed.

"T. Valko" wrote:

Format the cell as GENERAL

--
Biff
Microsoft Excel MVP

"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.

References:
- Re: Time formulas
  - From: T. Valko
- Re: Time formulas
  - From: T. Valko

Prev by Date: Re: Sumif
Next by Date: Re: Sumif
Previous by thread: Re: Time formulas
Next by thread: Re: Time formulas
Index(es):
- Date
- Thread