Convert Minute to Unit

New Member
Hi there,

I like to figure how to use same cell when I input time as for sample 12:15 pm at regular time but it change to army time to 12:25pm that it was minute convert to unit or "hundredth" because at Postal Service to use time figure that regular time not meet to decimal so we need use minute to unit to meet decimal for sample
Regular time
cell: A1 12:15 B1 14:45 C1 2.75(decimal)
Army time (unit or hundreth)
cell: A1 12:25 B1 14:75 C1 2.75 (2:45)
that it was use decimal for regular time but not good for to figure for mail volume that I need it change to army time itself in same cell when I input regular time so it will good to figure for mail volumes.
Linda

Excel Facts

Copy a format multiple times
Select a formatted range. Double-click the Format Painter (left side of Home tab). You can paste formatting multiple times. Esc to stop
Linda,

Military time still uses 60 minutes, don't understand the 14:75. But you can try this formula to convert to tenths. Enter in C1. I think this is what you want. Each tenth is equal to 6 minutes.

=CEILING(((B1-A1+(B1<A1))*24),0.1)

Hi Brian
I want to show u what minutes convert to hundredth called units
....Minutes = Hunderedth
....0 = .00.... 12 = .20
....1 = .02.... 13 = .22
....2 = .03.... 14 = .23
....3 = .05.... 15 = .25
....4 = .07.... 20 = .33
....5 = .08.... 25 = .42
....6 = .10.... 30 = .50
....7 = .12.... 35 = .58
....8 = .13.... 40 = .67
....9 = .15.... 45 = .75
....10 = .17.... 50 = .83
....11 = .18.... 55 = .92
................ 59 = .98

Now for sample: I input time in cell:
A1 12:15 that I want same cell to do change convert from time - minute to unit(decimal) to 12.25 itself;
14:45 change to 14.75 on cell B1 so on Cell C1 will show 2.50 = 2:30

I think first place I was mistake type from 12:15 to 12:25 that what I mean that is 12:15 to 12.25, I am sorry for bit of confused. I hope this one u might understand more better than first place.
Linda
This message was edited by WingUnicornLady on 2002-09-24 23:57

Linda,

In B1 enter:

=A1*24

where A1 houses a time value like 12:15. Format B1 as General.

In C1 enter:

=B1/24

Time format C1.

Linda,

=ceiling(((B1-A1+(B1< A1))*24),0.01)

However, I see Aladin has responded.

It's not picking up the whole formula...why is that?
This message was edited by Brian from Maui on 2002-09-25 00:25
This message was edited by Brian from Maui on 2002-09-25 00:35

On 2002-09-25 00:22, Brian from Maui wrote:
Linda,

=CEILING(((B1-A1+(B1<A1))*24),0.1)

However, I see Aladin has responded.

Brian

Disable HTML when a formula has a less than symbol...

Linda,

To get units in hundreds use in C1

=ceiling(((B1-A1+(B1 < A1))*24),0.01)

Format C1 to General

Replies
4
Views
541
Replies
7
Views
3K
Replies
3
Views
725
Replies
4
Views
464
Replies
7
Views
2K

1,220,965
Messages
6,157,122
Members
451,399
Latest member
alchavar

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.

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