# Time display as a number

#### RamRam

##### Board Regular
Hi, I am trying to get this to display as 37 not as 00:37 which it is at present.

The formula and info in use is to do with time which is
C D E F G H
Start End Duration Slots Time Total
09:00 12:05 03:05 12 5 00:37

Start 09:00
End 12:05
Duration 03:05 =formula D5-C5
Slots per Hr Req =12 (devide 12 into 03:05 giving you 5 min per slot)
Time Slot Min = 5
Possible Slots = 00:37 (e5/g5)

### Excel Facts

What do {} around a formula in the formula bar mean?
{Formula} means the formula was entered using Ctrl+Shift+Enter signifying an old-style array formula.
Hmm..

This works fine. Format the 5 to minute format or enter it as 00:05
and dividing 3:05 by that gives 37 with no formatting issues. but 3:05 divided by just 12 = 00:15 minutes, so I assumed you met divide 1 hour by 12 to get 12 5 minute intervals per hour.
Book1
ABCDEF
1
29:0012:053:05120:0537
3
Sheet1

Try this formula

=E5/G5*24*60

and format the cell as General.

Thank you

Thanks for the quick reply both work but Norie, yours was the quickest to impliment. Thank you both very much

Glad to be of little assistance. I didn;t realize C5/E5 was so much harder than Norie's solution. Guess that is why he gets 10 stars!

I know he is always dead on when I need help!

I imagine you could also use

=E5*F5*24

although what happens if your time period in E5 is not a multiple of 5 mins?

Replies
4
Views
171
Replies
6
Views
781
Replies
8
Views
2K
Replies
6
Views
413
Replies
5
Views
355

1,211,869
Messages
6,104,474
Members
447,911
Latest member
rkramapo

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