Results 1 to 4 of 4

Thread: Time Conversion
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular
    Join Date
    Jan 2009
    Posts
    87
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Time Conversion

    Hi

    I have the following problem. I am trying to automate a time-sheet but I am having a problem converting .30hrs to 0.50hrs.

    For example:
    C4 I have the start time 08.00
    D4 I have the finish time 08.30
    E4 I have D4-C4 which equals 0.30

    C4 I have the start time 08.00
    D4 I have the finish time 08.15
    E4 I have D4-C4 which equals 0.15

    C4 I have the start time 07.45
    D4 I have the finish time 08.30
    E4 I have D4-C4 which equals 0.85

    Is it possible to convert .30 to display 0.50, 0.15 to display 0.25 and 0.85 to display as 0.75.

    This would help with adding the weekly hours.


    Thank you very much,

    L

  2. #2
    MrExcel MVP shg's Avatar
    Join Date
    May 2008
    Location
    The Great State of Texas
    Posts
    21,611
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    14 Thread(s)

    Default Re: Time Conversion

    c
    d
    e
    f
    4
    8.00
    8.30
    0.50
    e4: =dollarde(d4, 60) - dollarde(c4, 60)
    5
    8.00
    8.15
    0.25
    6
    7.45
    8.30
    0.75

  3. #3
    Board Regular
    Join Date
    Jan 2009
    Posts
    87
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Time Conversion

    Quote Originally Posted by shg View Post
    c
    d
    e
    f
    4
    8.00
    8.30
    0.50
    e4: =dollarde(d4, 60) - dollarde(c4, 60)
    5
    8.00
    8.15
    0.25
    6
    7.45
    8.30
    0.75
    shg that works fantastically well! Thank you so much

  4. #4
    MrExcel MVP shg's Avatar
    Join Date
    May 2008
    Location
    The Great State of Texas
    Posts
    21,611
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    14 Thread(s)

    Default Re: Time Conversion

    You're welcome.

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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