# Calculating times

#### stafire_18

##### Board Regular
I can not get the calculation to round to the next hour once the minutes hit 60

Begin time
Tuesday, November 19, 2013 5:39 AM Tuesday,

End time
November 19, 2013 1:38 PM 5:39 AM 1:38 PM 7.98

Formula is =((RIGHT(A29,7)-RIGHT(B29,7))*24)

Returing Value
7.98

### Excel Facts

How can you turn a range sideways?
Copy the range. Select a blank cell. Right-click, Paste Special, then choose Transpose.
Bit confuse...
What are the values on cells A29 and B29?

It's better if you tell us the result you want rather than the unwanted result that your formula produces.

Does this do what you need?

=ROUNDUP((B29-A29)*24,0)

Bit confuse...
What are the values on cells A29 and B29?

A29 holds Tuesday, November 19, 2013 5:39 AM
B29 holds Tuesday, November 19, 2013 1:38 PM

For example the total time should be 7 hours .59 minutes. So a process started at 5:39am and ends at 1:38 pm if it was 1:39 pm then it would have taken 8 hours to process, because the process completed at 1:38 (1 minute shy) then it took 7.59 miutes to complete. My formula is saying it took 7.98 . thx guys.

If the cells are holding actual dates, maybe just =(B29-A29+0) and change the reporting cell's format to hh:mm

Hope that helps,

Mark

thx!

Replies
5
Views
151
Replies
5
Views
265
Replies
9
Views
99
Replies
4
Views
567
Replies
6
Views
581

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