Time
 

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

Time
 

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

Time
 

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" wrote in message
...
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

Time
 

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" wrote in message ...
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

Time
 

Thank you Ron,

Excellent info and formulas.
Appricate it very much.

Eric
"Ron de Bruin" wrote in message ...
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" wrote in message ...
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