Time

[Window Guy]

Trying to set up a simple time schedule.
Thought I knew how to do this.
Beginning time - End time = hours & minutes worked

Please help
Thanks
Eric

[Jim Thomlinson]

Wouldn't it be ending time - beginning time? There are days when I have quit
even before I started but that probably does not apply in this case.
--
HTH...

Jim Thomlinson


"Window Guy" wrote:

> Trying to set up a simple time schedule.
> Thought I knew how to do this.
> Beginning time - End time = hours & minutes worked
>
> Please help
> Thanks
> Eric

[Chip Pearson]

Eric,

You want to use the following VBA

End_Time - Begin_Time - (End_Time<Begin_Time)

This assumes you have times without dates. If you have dates and
times, just use
End_Time - Begin_Time

In both cases, format the cell with a custom format of [hh]:mm or
[hh]:mm:ss



--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Window Guy" <[email protected]> wrote in message
news:[email protected]...
Trying to set up a simple time schedule.
Thought I knew how to do this.
Beginning time - End time = hours & minutes worked

Please help
Thanks
Eric

[Ron de Bruin]

Hi Eric

See Chip Pearson's site
http://www.cpearson.com/excel/overtime.htm

See also the links on the bottom of this page


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Window Guy" <[email protected]> wrote in message news:[email protected]...
Trying to set up a simple time schedule.
Thought I knew how to do this.
Beginning time - End time = hours & minutes worked

Please help
Thanks
Eric

[Window Guy]

Thank you Ron,

Excellent info and formulas.
Appricate it very much.

Eric
"Ron de Bruin" <[email protected]> wrote in message news:uC4V%[email protected]...
Hi Eric

See Chip Pearson's site
http://www.cpearson.com/excel/overtime.htm

See also the links on the bottom of this page


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Window Guy" <[email protected]> wrote in message news:[email protected]...
Trying to set up a simple time schedule.
Thought I knew how to do this.
Beginning time - End time = hours & minutes worked

Please help
Thanks
Eric