+ Reply to Thread
Results 1 to 5 of 5

military time function

  1. #1
    Beth
    Guest

    military time function

    is there a function to convert regular time entered into cell into military
    time?

  2. #2
    Jake Marx
    Guest

    Re: military time function

    Hi Beth,

    Beth wrote:
    > is there a function to convert regular time entered into cell into
    > military time?


    It depends on what you're trying to do. If you need the military time as a
    string (text), you could do this:

    =TEXT(A1,"hh:mm:ss")

    If you just need a cell that contains a time entered as 8:30 PM to display
    20:30:00, you can simply format the cell:

    1) Select the cell, right click, choose Format Cells...

    2) Select "Time" from the listbox on the left, then choose the format
    that looks like Military Time (3rd from last on my machine)

    --
    Regards,

    Jake Marx
    MS MVP - Excel
    www.longhead.com

    [please keep replies in the newsgroup - email address unmonitored]


  3. #3
    Beth
    Guest

    Re: military time function

    the time frame that we are use for these specific sheets is 6am - midnight.
    So if 1:00 is entered I need it to automatically change to 13:00 it can never
    be 1:00 (users don'yt know military time). And I was wondering how I could
    make this happen in a certain cell.
    Thanks for your response but I think it's more than a formatiing issue it
    calls for an acutal function or macro maybe, after all data is entered then a
    button is clicked and then all time entries are transformed in the designated
    cells. I should have been more specific sorry any adive that you have would
    be great, thanks.

    "Jake Marx" wrote:

    > Hi Beth,
    >
    > Beth wrote:
    > > is there a function to convert regular time entered into cell into
    > > military time?

    >
    > It depends on what you're trying to do. If you need the military time as a
    > string (text), you could do this:
    >
    > =TEXT(A1,"hh:mm:ss")
    >
    > If you just need a cell that contains a time entered as 8:30 PM to display
    > 20:30:00, you can simply format the cell:
    >
    > 1) Select the cell, right click, choose Format Cells...
    >
    > 2) Select "Time" from the listbox on the left, then choose the format
    > that looks like Military Time (3rd from last on my machine)
    >
    > --
    > Regards,
    >
    > Jake Marx
    > MS MVP - Excel
    > www.longhead.com
    >
    > [please keep replies in the newsgroup - email address unmonitored]
    >
    >


  4. #4
    Jake Marx
    Guest

    Re: military time function

    Beth,

    Beth wrote:
    > the time frame that we are use for these specific sheets is 6am -
    > midnight. So if 1:00 is entered I need it to automatically change to
    > 13:00 it can never be 1:00 (users don'yt know military time). And I
    > was wondering how I could make this happen in a certain cell.
    > Thanks for your response but I think it's more than a formatiing
    > issue it calls for an acutal function or macro maybe, after all data
    > is entered then a button is clicked and then all time entries are
    > transformed in the designated cells. I should have been more specific
    > sorry any adive that you have would be great, thanks.


    You could do something like this with worksheet event routines, but here's
    the big question: what do you want to happen if someone enters 6:00 - assume
    it's 06:00 or change it to 18:00?

    If you format the cells as military time, then Excel will display them
    correctly for you. But that means the user would have to put the AM or PM
    after the time so Excel could determine what they wanted.

    --
    Regards,

    Jake Marx
    MS MVP - Excel
    www.longhead.com

    [please keep replies in the newsgroup - email address unmonitored]


  5. #5
    Jim at Eagle
    Guest

    RE: military time function

    Beth, I would provide a time entry popup form where user would select by
    radio button the time. This can be very slick and useful or clumsy and
    painful in the ... Be careful how you implement.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

X vBulletin 4.1.8 Debug Information

  • Page Generation 1.09568 seconds
  • Memory Usage 8,907KB
  • Queries Executed 16 (?)
More Information
Template Usage (30):
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_global_above_footer
  • (1)ad_global_below_navbar
  • (1)ad_global_header1
  • (1)ad_global_header2
  • (1)ad_navbar_below
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (1)ad_thread_first_post_content
  • (1)ad_thread_last_post_content
  • (1)footer
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)headinclude_bottom
  • (5)memberaction_dropdown
  • (1)navbar
  • (4)navbar_link
  • (4)navbar_noticebit
  • (6)option
  • (5)postbit_legacy
  • (5)postbit_wrapper
  • (4)showthread_bookmarksite
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper
  • (1)vbseo_linkbackmenu_entry 

Phrase Groups Available (6):
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files (40):
  • ./vbseo.php
  • ./env.php
  • ./vbseo/includes/functions_vbseo.php
  • ./vbseo/includes/functions_vbseo_pre.php
  • ./vbseo/includes/functions_vbseo_url.php
  • ./vbseo/includes/functions_vbseo_createurl.php
  • ./vbseo/includes/functions_vbseo_db.php
  • ./vbseo/includes/functions_vbseo_vb.php
  • ./vbseo/includes/functions_vbseo_seo.php
  • ./vbseo/includes/functions_vbseo_misc.php
  • ./vbseo/includes/functions_vbseo_crr.php
  • ./vbseo/includes/functions_vbseo_cache.php
  • ./vbseo/includes/functions_vbseo_hook.php
  • ./vbseo/includes/functions_vbseo_startup.php
  • ./includes/config.php
  • ./showthread.php
  • ./global.php
  • ./includes/class_bootstrap.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/functions.php
  • ./includes/class_friendly_url.php
  • ./includes/class_hook.php
  • ./includes/functions_cforum.php
  • ./includes/functions_facebook.php
  • ./includes/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/class_bootstrap_framework.php
  • ./vb/vb.php
  • ./vb/phrase.php
  • ./packages/vbattach/attach.php
  • ./vb/types.php
  • ./vb/cache.php
  • ./vb/cache/db.php
  • ./vb/cache/observer/db.php
  • ./vb/cache/observer.php
  • ./includes/functions_notice.php
  • ./includes/functions_prefix.php 

Hooks Called (44):
  • init_startup
  • friendlyurl_resolve_class
  • database_pre_fetch_array
  • database_post_fetch_array
  • global_bootstrap_init_start
  • global_bootstrap_init_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • global_state_check
  • global_bootstrap_complete
  • global_start
  • style_fetch
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • friendlyurl_redirect_canonical
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • fetch_musername
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • cache_templates
  • template_register_var
  • parse_templates
  • notices_check_start
  • notices_noticebit
  • process_templates_complete
  • memberaction_dropdown
  • tag_fetchbit_complete
  • forumrules
  • showthread_bookmarkbit
  • navbits
  • navbits_complete
  • showthread_complete


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1