About Us

DonElston

We have a shift that runs from 19:00 until 07:00 the next day. How can I get
Excel to calculate the hours without the necessity of adding a date to the
cell.

Roger Govier

Hi Don

With start time in A1 and end time in B1
=MOD(B1-A1,1)

--
Regards

Roger Govier

"DonElston" wrote in message
...
We have a shift that runs from 19:00 until 07:00 the next day. How
can I get
Excel to calculate the hours without the necessity of adding a date to
the
cell.

Teethless mama

=MOD(B1-A1,1)
or
=(B1-A1)+(A1B1)

"DonElston" wrote:

We have a shift that runs from 19:00 until 07:00 the next day. How can I get
Excel to calculate the hours without the necessity of adding a date to the
cell.

Mike H

Start time =A1
End time = B1

Try:-

=(B1-A1+(B1<A1))*24

Mike

"DonElston" wrote:

We have a shift that runs from 19:00 until 07:00 the next day. How can I get
Excel to calculate the hours without the necessity of adding a date to the
cell.

DonElston

THanks so much, it worked great.

DOn

"Teethless mama" wrote:

=MOD(B1-A1,1)
or
=(B1-A1)+(A1B1)

"DonElston" wrote:

We have a shift that runs from 19:00 until 07:00 the next day. How can I get
Excel to calculate the hours without the necessity of adding a date to the
cell.

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How do I calculate total child custody overnights?	bk	Excel Discussion (Misc queries)	2	May 24th 07 05:07 PM
Timesheet	ChrisMattock	Excel Worksheet Functions	10	July 6th 06 04:04 PM
Timesheet	MyKidsBank	Excel Worksheet Functions	1	April 24th 06 02:21 AM
timesheet with OT	mike	New Users to Excel	2	October 15th 05 12:06 AM
Timesheet	Doug	Excel Worksheet Functions	1	March 3rd 05 07:53 PM

Menu

About Us