# Splitting the Count of Minutes

#### Atom Ant

##### New Member
So I've got a spreadsheet which has a "Start Time/Date" in one cell (A1) and an "End Time/Date" in the next (B1). I have it figured out how to calculate the duration in minutes, (B1-A1)*1440. Easy enough.

Here's my problem. I need to figure out how to keep the "Start Time/Date" in one cell and "End Date/Time" in the other cell while being able to count "Peak" and "Non-Peak" minutes.

For example, say I have an incident that starts 06/30/2008 4:30 PM and ends 06/30/2008 7:00 PM. Peak time is from 8:00 AM - 6:00 PM on weekdays. I want to be able to show that 90 minutes should be distributed to a "Peak Minutes" cell and the final 60 minutes should be distributed to a "Non-Peak Minutes" cell.

To further complicate things, I need to show "Peak" and "Non-Peak" minutes for incidents that span multiple days, where Saturday and Sunday are considered "Non-Peak" along with 12:00 AM - 7:59 AM and 6:01 PM - 11:59 PM on weekdays.

Is there any hope?

### Excel Facts

How to show all formulas in Excel?
Press Ctrl+` to show all formulas. Press it again to toggle back to numbers. The grave accent is often under the tilde on US keyboards.

Replies
3
Views
2K
Replies
3
Views
619
Replies
2
Views
443
Replies
0
Views
483
Replies
8
Views
1K

1,190,918
Messages
5,983,578
Members
439,852
Latest member
balasat

### 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.
Allow Ads at MrExcel

### Which adblocker are you using?

Follow these easy steps to disable AdBlock

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

### Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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