# Return hours scheduled

#### pheonix1

##### New Member
I am working on creating an employee schedule for my work and I cannot figure out how to return a value for say a scheduled shift of 1030-6 or 11-6 in a single cell.
If there is a formula for this what would it be?

### Excel Facts

Which came first: VisiCalc or Lotus 1-2-3?
Dan Bricklin and Bob Frankston debuted VisiCalc in 1979 as a Visible Calculator. Lotus 1-2-3 debuted in the early 1980's, from Mitch Kapor.
Hello and welcome to MrExcel.

Does this help?

<b>Sheet10</b><br /><br /><table border="1" cellspacing="0" cellpadding="0" style="font-family:Calibri,Arial; font-size:11pt; background-color:#ffffff; padding-left:2pt; padding-right:2pt; "> <colgroup><col style="font-weight:bold; width:30px; " /><col style="width:64px;" /><col style="width:64px;" /><col style="width:93px;" /></colgroup><tr style="background-color:#cacaca; text-align:center; font-weight:bold; font-size:8pt; "><td > </td><td >A</td><td >B</td><td >C</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >1</td><td >Start</td><td >End</td><td >Shift duration</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >2</td><td style="text-align:right; ">08:30</td><td style="text-align:right; ">17:15</td><td style="text-align:right; ">08:45</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >3</td><td style="text-align:right; ">22:15</td><td style="text-align:right; ">06:30</td><td style="text-align:right; ">08:15</td></tr></table><br /><table style="font-family:Arial; font-size:10pt; border-style: groove ;border-color:#00ff00;background-color:#fffcf9; color:#000000; "><tr><td ><b>Spreadsheet Formulas</b></td></tr><tr><td ><table border = "1" cellspacing="0" cellpadding="2" style="font-family:Arial; font-size:9pt;"><tr style="background-color:#cacaca; font-size:10pt;"><td >Cell</td><td >Formula</td></tr><tr><td >C2</td><td >=MOD(B2-A2,1)</td></tr><tr><td >C3</td><td >=MOD(B3-A3,1)</td></tr></table></td></tr></table> <br />Excel tables to the web - Excel Jeanie Html 4

Hello Pheonix1, welcome to MrExcel

I'd advise you to put the start and end times in different cells, then you can get the time worked more easily, e.g.

A2 has start time, e.g. 09:00, B2 has end time e.g. 17:00 and C2 has the formula

=B2-A2

You can use any valid time format, e.g. you might want the times to be 9:00 AM and 6:00 PM, formula will be the same....

see here for more on timesheets

Replies
1
Views
236
Replies
5
Views
110
Replies
1
Views
273
Replies
9
Views
158
Replies
6
Views
574

1,221,409
Messages
6,159,711
Members
451,587
Latest member
srice33

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back