Time display as a number

RamRam

Board Regular
Joined
Nov 14, 2002
Messages
52
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)

Any help please :LOL:
 

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
 
Upvote 0
Try this formula

=E5/G5*24*60

and format the cell as General.
 
Upvote 0
Thank you

Thanks for the quick reply both work but Norie, yours was the quickest to impliment. Thank you both very much
 
Upvote 0
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!
 
Upvote 0
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?
 
Upvote 0

Forum statistics

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

Which adblocker are you using?

Disable AdBlock

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
Back
Top