Is military time available in Excel? If so, how would I calcu



  • 1. Average time between 2 dates
    Hi I am tryed to put together some formulas to work the average time taken for this below information but i have got myself all muddled up and I bet the solution is fairly straightforward I want to work out the average time between the firstapproved date and the actual start date to work out the average time taken to start all jobs logged. I would like the information in hours I know it should be straight forward but my brain has gone a bit fried A1 A2 FIRSTAPPROVED ACTSTART 09/11/2006 12:05 14/11/2006 11:35 17/11/2006 12:05 20/11/2006 10:20 01/12/2006 13:20 04/12/2006 17:16 Thank you very much
  • 2. importing data form access
    not sure how to even approach this, what I have is a table in access that I only want the last record to lookup or import into excel from access is this possible? Thanks in advance
  • 3. Mode Statistic Function
    Hello, I would like to calculate the mode for service start dates within an order for a large number of orders. The orders contain a variable number of line items where each line item contains a start date. How may I apply "mode" and have the calculation restart for each new order number?
  • 4. Automatically change case is Excel when typed
    I have two worksheets that I need to automatically change the case to Upper regardless of how it was typed in the first place. In one worksheet, the range is Column C and in the second worksheet, the range is Column B. From looking at various entries from other people, I have a code (see below) to use which works on one sheet, but not on the other. I'm not sure if it is because I already have a code to change the colour of cells depending on their criteria. Please help. Private Sub Worksheet_Change(ByVal Target As Range) Const WS_RANGE As String = "B:B" '<== change to suit On Error GoTo ws_exit Application.EnableEvents = False If Not Intersect(Target, Me.Range(WS_RANGE)) Is Nothing Then With Target If Not .HasFormula Then .Value = UCase(.Value) End If End With End If ws_exit: Application.EnableEvents = True End Sub

Re: Is military time available in Excel? If so, how would I calcu

Postby dGltcA » Mon, 14 Feb 2005 04:35:04 GMT

basic spreadsheet as follows:
0800 start time, 1200pm end time, total time
These blocks of time represent jobs, and there will be 4 jobs on one sheet.

how do I format the cells (i.e., by number, time, general)

Re: Is military time available in Excel? If so, how would I calcu

Postby Peo Sjoblom » Mon, 14 Feb 2005 05:20:38 GMT

You can use the formula I provided, replace B1 with your end time cell and 
A1 with your start time cell
format as hh:mm to get time excel can understand


Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)

Similar Threads:

1.Display standard time without "AM or PM" while entering in military time


I am creating a time sheet. Any help would be appreciated.
I have 4 cells:
1. IN (time cell)
2. OUT ( time cell)
3. Lunch (time cell)
4. Total Hrs(number cell)

When I enter in military such as 16:30 I would like it to display 4:3
withou the "PM or AM"
I have tried the format  (h:mm) and custom  options and have bee
unable to display as "00:00".

Can you please help.
Thank yo

2.Concatenate Function/converting military time to AM/PM

I wrote the formula below to display time that was originally in two separate 
cells into one cell separated by a " - ".  It works accept the result is 
displayed in military time and not in AM/PM.  Any help would be appreciated.  

=CONCATENATE(TEXT(B7,"h:mm")," - ",TEXT(C7,"h:mm"))


3.Converting Standard Time to Military Time in Excel

What function can be used to convert a column of Standard Time to a column of 
Military Time in Excel?
Is it a formula or formatting?

4.Converting Standard Time into Military Time

I have a column of standard times (example 6:50pm) that need to be converted 
to military times (example 18:50); is there a formula or formatting feature 
that can convert the entire column?  

5.formula for converting military time to standard time, etc

I have 5 cells in a row (A1 - A5).  I need to subtract, in military time, A1 
from A2 and then A3 from A4 and the total should be in A5 as standard time.  
Cells A1-A4 are formatted as hhmm and cell A5 is formatted as hh:mm.

6. Military time viewed as civilian time

7. Calculating time without using military time

8. Converting time into military time

Return to MS EXCEL


Who is online

Users browsing this forum: No registered users and 87 guest