Hello,
I am using the following formula to calculate time in military format but it is not providing the desired results:
=(TRUNC(C2/100)-TRUNC(B2/100))/24+(MOD(C2,100)-MOD(B2,100))/1440+IF(C2<B2,1)
I have attached the file for assistance.
Thanks a bunch.Start & Stop In Military Time.xlsx
try
=MOD(C2-B2,1)
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
Hello MartindWilson,
I added your above function and thought the result on the following should have been 12:03:
74712 21:48 9:45 11:56
Can you please take a look at my attached file and advise what I am doing wrong?
Try this in D2 and drag down.
Please Login or Register to view this content.
21:48 09:45
21:48 is 2:12 till midnite
+9:45
=11:57
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks