# Compute number of hrs

#### Woodduck838

##### New Member
What formula will i use to compute the number of hour from start time to end time? Example i want to compute 8:00 am to 5:00 pm

### Excel Facts

How to fill five years of quarters?
Type 1Q-2023 in a cell. Grab the fill handle and drag down or right. After 4Q-2023, Excel will jump to 1Q-2024. Dash can be any character.

#### iliace

##### Well-known Member
Excel Workbook
DEFG
18FromToTime ValueHours
198:0015:007:007.00
dooba

#### VoG

##### Legend
One way

<b>Sheet1</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:64px;" /></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 style="text-align:right; ">08:00</td><td style="text-align:right; ">17:00</td><td style="text-align:right; ">09:00</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >2</td><td style="text-align:right; ">21:00</td><td style="text-align:right; ">03:30</td><td style="text-align:right; ">06:30</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 >C1</td><td >=MOD(B1-A1,1)</td></tr><tr><td >C2</td><td >=MOD(B2-A2,1)</td></tr></table></td></tr></table> <br />Excel tables to the web - Excel Jeanie Html 4

#### Guanjin Peter

##### Active Member
awesome. I can learn from this too!
Hope I can grow strong in programming like you guys!
Man...do you guys do science and leave people wondering all the time?

#### Woodduck838

##### New Member
Thank you so much iliace that was very helpful

woodduck838

#### Woodduck838

##### New Member
Thank you Iliace, That was very helpful.

#### Woodduck838

##### New Member
Thank you so muck Vo II, that was very helpful.

woodduck838

Replies
2
Views
252
Replies
2
Views
414
Replies
11
Views
251
Replies
1
Views
219
Replies
2
Views
359

1,191,191
Messages
5,985,213
Members
439,947
Latest member
fabiannic

### 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