Converting time into military time

[Michelle Bocchietti]

Example

6:15 am
8:26 am

The answer that I am looking for is 2:18 worked. Can you give me a formula
for this problem

 

[Peo Sjoblom]

=end-start

format as [h]:mm


--


Regards,


Peo Sjoblom

 

[Michelle Bocchietti]

Hi Peo,
The formula you stated is correct however it is in minutes not miliatry. If
you use the formula =end-start the answer would be 2:11. I am looking for
military time which would be 2:18

=end-start

format as [h]:mm


--


Regards,


Peo Sjoblom

Example

6:15 am
8:26 am

The answer that I am looking for is 2:18 worked. Can you give me a
formula
for this problem

 

[Peo Sjoblom]

I don't think that is called military time, normally military time is when
you write
02:00 PM as 1400

=ROUND((B1-A1)*24,2)

It sounds as though you want decimal time, with end in B1 and start in A1

format as general will give you

2.18

to get 2:18 you would need some stupid text variety

=TEXT(B1-A1,"[h]")&":"&ROUND(MOD((B1-A1)*24,1)*100,0)


--


Regards,


Peo Sjoblom

Hi Peo,
The formula you stated is correct however it is in minutes not miliatry.
If
you use the formula =end-start the answer would be 2:11. I am looking for
military time which would be 2:18

=end-start

format as [h]:mm


--


Regards,


Peo Sjoblom



"Michelle Bocchietti" <Michelle (e-mail address removed)>
wrote
in message news:[email protected]...

Example

6:15 am
8:26 am

The answer that I am looking for is 2:18 worked. Can you give me a
formula
for this problem