Converting time into military time

  • Thread starter Thread starter Michelle Bocchietti
  • Start date Start date
M

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

Peo Sjoblom said:
=end-start

format as [h]:mm


--


Regards,


Peo Sjoblom



Michelle Bocchietti said:
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
Click to expand...
Click to expand...
 
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





Michelle Bocchietti said:
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

Peo Sjoblom said:
=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
Click to expand...
Click to expand...
Click to expand...
 
Back
Top