Welcome to OnlineConversion.com Forums 

Convert and Calculate Post any conversion related questions and discussions here. If you're having trouble converting something, this is where you should post. * Guest Posting is allowed. 

Thread Tools  Display Modes 
#1




MILITARY time conversion
I need to enter a clock in and clock out time and then convert this to hours.
I tried this formula =(QUOTIENT(B1,100)QUOTIENT(A1,100))/24+(MOD(B1,100)MOD(A1,100))/1440+IF(B1<A1,1) But I keep getting the #NAME Error.... Can someone please help me out? 
#2




Re: MILITARY time conversion
Quote:

#3




Re: MILITARY time conversion
all I can tell u is 20:25 = 8:25 pm and 16:50 = 4:50 pm..the military clock is simply a 24 hour clock with 24 hours vice having two sets of 12 hour time frames. 1pm is 1300 hours, 1 am is 0100 hours.

#4




Re: MILITARY time conversion
General hints:
Break the formula up into pieces and see if the pieces work, QUOTIENT(B1,100) in one cell and QUOTIENT(A1,100) in another cell if that works, put them together and try (QUOTIENT(B1,100)QUOTIENT(A1,100))/24 Continue on with other parts of the formula until you discover what is causing the error. RB 
#5




Re: MILITARY time conversion
I am having problems converting time to hours. I am looking for a way to convert it or to understand it in a more simple way. What I do when the
employee clock in I take the time against the audit report which has hours on it and convert the clock in time to hours. Help, 
#6




Re: MILITARY time conversion
Quote:
Returns the integer portion of a division. Use this function when you want to discard the remainder of a division. If this function is not available, and returns the #NAME? error, install and load the Analysis ToolPak addin. On the Tools menu, click AddIns.
__________________
duct tape duct tape it's better than glue fixes stuff just like new be prepared throughout your life keep a roll beneath your pillow at night 
#7




Re: MILITARY time conversion
in excel format your cell to military time you can put in the regular time ie 3:30 PM and it will convert it to military time

#8




Re: MILITARY time conversion
Quote:
If you cannot or do not want to load the Analysis ToolPak, there is an alternative solution. The following formula produces the same results as the QUOTIENT formula, but uses Excel intrinsic functions only: =(TRUNC(B1/100)TRUNC(A1/100))/24+(MOD(B1,100)MOD(A1,100))/1440+IF(B1<A1,1)Don't forget to format the output cell(s) using a 24hour time format, such as "13:30". 
Thread Tools  
Display Modes  

