Convert Minute to Unit

WingUnicornLady

New Member
Joined
Sep 12, 2002
Messages
2
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

How to fill five years of quarters?
Type 1Q-2023 in a cell. Grab the fill handle and drag down or right. After 4Q-2023, Excel will jump to 1Q-2024. Dash can be any character.

Brian from Maui

MrExcel MVP
Joined
Feb 16, 2002
Messages
8,458
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)

Formula credited to Aladin
 

WingUnicornLady

New Member
Joined
Sep 12, 2002
Messages
2
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
 

Aladin Akyurek

MrExcel MVP
Joined
Feb 14, 2002
Messages
85,209
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.

Aladin
 

Brian from Maui

MrExcel MVP
Joined
Feb 16, 2002
Messages
8,458

ADVERTISEMENT

Linda,


With apologies to Aladin, the orignal formula should read:

=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
 

Aladin Akyurek

MrExcel MVP
Joined
Feb 14, 2002
Messages
85,209
On 2002-09-25 00:22, Brian from Maui wrote:
Linda,


With apologies to Aladin, the orignal formula should read:

=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...
 

Brian from Maui

MrExcel MVP
Joined
Feb 16, 2002
Messages
8,458
Linda,

To get units in hundreds use in C1

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

Format C1 to General
 

Forum statistics

Threads
1,143,704
Messages
5,720,378
Members
422,281
Latest member
jantoooh

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
Top