Re: Time Calculations
- From: "Biff" <biffinpitt@xxxxxxxxxxx>
- Date: Fri, 22 Apr 2005 23:02:46 -0400
Hi!
Try this with the cell formatted as [h]:mm if you want the result to show as
4:00
=B2-A2+(A2>B2)
Try this with the cell formatted as GENERAL if you want the result to show
as 4
=(B2-A2+(A2>B2))*24
Biff
"Paul T" <Paul T@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:8932B33E-3465-4D33-9E95-416CE36A5CBA@xxxxxxxxxxxxxxxx
> In excel I want to track line efficiencies based on time. I need to know
> how
> to subtract 1 time from another. I do not appear to have any trouble with
> adding times.
>
> Cell A1 Cell B1 Cell c1
> Start Time End Time Hours worked
> 23:00 03:00 (should be 4 but all I get is
> hash
> symbols)
>
> Ideally I do not want to ann in date and times. Is there a simple formula
> I
> have not tried?
>
>
.
- References:
- Time Calculations
- From: Paul T
- Time Calculations
- Prev by Date: Time Calculations
- Next by Date: Need to switch 2 columns with each other...please help
- Previous by thread: Time Calculations
- Next by thread: Need to switch 2 columns with each other...please help
- Index(es):
Relevant Pages
|
