Convert Minute to Unit

[WingUnicornLady]

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

 

[Brian from Maui]

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]

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]

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]

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]

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]

Linda,

To get units in hundreds use in C1

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

Format C1 to General