Jump to content
Sign in to follow this  
Leather Knight

Calcualting Time

Recommended Posts

I have 2 fields that are times(start time and end time) I also have a total time field. The first 2 are set as "11:00 PM" and I want the total time field to show the total time without the "am/pm". How do I make it do that?

Share this post


Link to post
Share on other sites

right click on the field and change the time formatting. You can have it as 24 hour notation.

Share this post


Link to post
Share on other sites

I can't use military time format, because they use standard and it would confuse some using it.

And it still does not calculate right, if you start at 8 am and end at 4 pm the total time worked should show "8" but shows -14000

Share this post


Link to post
Share on other sites

The Total Time field should be a calc with the result type Time. Then format that field using 24-hour notation. It will show the time in the format: 8:00:00 (or whatever bits you wish to include in the format).

Share this post


Link to post
Share on other sites

Perhaps you should reveal the formula your calculation is using (my crystal ball is being repaired at the moment). See also here.

Edited by Guest

Share this post


Link to post
Share on other sites

YOU... have a crystal ball?

LOL!

Share this post


Link to post
Share on other sites

It reminds me of a joke I heard the other day:

"Why is it nessersary to book a time for a session with a clairvoyant"

--sd

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.