Jump to content

Welcome to Geeks to Go - Register now for FREE

Need help with your computer or device? Want to learn new tech skills? You're in the right place!
Geeks to Go is a friendly community of tech experts who can solve any problem you have. Just create a free account and post your question. Our volunteers will reply quickly and guide you through the steps. Don't let tech troubles stop you. Join Geeks to Go now and get the support you need!

How it Works Create Account
Photo

Excel Formula - Time Card Calculator

Started by Jhazon , Mar 11 2013 09:30 AM

  • Please log in to reply

#1
Jhazon
Posted 11 March 2013 - 09:30 AM

Jhazon

    Member

  • Member
  • PipPipPip
  • 109 posts
I am looking help with an excel worksheet... one that will provide me with two "total time" outputs... one being total time (0-60) and the other being metric or flow time (0-100)

For example: 11:00 AM - 4:30 PM would provide 5.15 as well as 5.25...
  • 0

Advertisements

#2
Jhazon
Posted 11 March 2013 - 09:45 AM

Jhazon

    Member

  • Topic Starter
  • Member
  • PipPipPip
  • 109 posts
Posted Image

Above is what I have already; I would like G3 to display 1.75
  • 0

#3
Jhazon
Posted 11 March 2013 - 12:30 PM

Jhazon

    Member

  • Topic Starter
  • Member
  • PipPipPip
  • 109 posts
Found my answer.... for cell G3, I used the formula =E3*24 and then set the format of the cell to "General". Works great!

Edited by Jhazon, 11 March 2013 - 12:30 PM.

  • 0
Back to Office · Next Unread Topic →




Similar Topics

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

  1. Geeks to Go Community
  2. → Software
  3. → Office

As Featured On:

Microsoft Yahoo BBC MSN PC Magazine Washington Post HP