Benches Uncategorized

12

Make a formula to convert time to decimals

apple Verified

Imported from the Apple Support Forums via the Wayback Machine 🔗

I am trying to set up a Numbers spreadsheet to convert Clock in and Clock out times to Decimal numbers.

So Clock in at 8:00 am Clock out at 10:15 would show 2.25

The formula's I've tried to create give me a Syntax error. I really am new to even creating formulas, but Trying to help other employees keep track of hours worked.

12 replies

Sign in or join Beachball Help to reply.

  1. 0

    Yellowbox

    Imported from the Apple Support Forums via the Wayback Machine 🔗

    Hi rhalladay,

    The DUR2HOURS function is your friend.

    Formula in D2 =DUR2HOURS(C2−B2)

    Regards,

    Ian.

  2. 0

    Badunit

    Imported from the Apple Support Forums via the Wayback Machine 🔗

    =DUR2HOURS(C2-B2)

    Edit: Jeez, I get up and do something else for a few minutes and I end up third at bat.

  3. 0

    rhalladay99

    Imported from the Apple Support Forums via the Wayback Machine 🔗

    I have Column C2-B2=D2, But I need D2 instead of being hours:minutes to show as a decimal.

  4. 0

    Wayne Contello

    Imported from the Apple Support Forums via the Wayback Machine 🔗

    use the formula:

    =DUR2HOURS(C2-B2)

  5. 0

    Yellowbox

    Imported from the Apple Support Forums via the Wayback Machine 🔗

    Hi rhalladay,

    The DUR2HOURS function is your friend.

    Formula in D2 =DUR2HOURS(C2−B2)

    Regards,

    Ian.

  6. 0

    Badunit

    Imported from the Apple Support Forums via the Wayback Machine 🔗

    =DUR2HOURS(C2-B2)

    Edit: Jeez, I get up and do something else for a few minutes and I end up third at bat.

  7. 0

    rhalladay99

    Imported from the Apple Support Forums via the Wayback Machine 🔗

    So I've gotten the Duration, Now I'm running into these Triangles when I'm trying to copy the formula into other cells that have no data.

    Will I just have to deal with these Triangles until data is entered??

  8. 0

    Badunit

    Imported from the Apple Support Forums via the Wayback Machine 🔗

    Seems strange you don't have more error triangles than that.

    =IFERROR(DUR2HOURS(C2-B2),"")

    or

    =IFERROR(DUR2HOURS(C2-B2),0)

    depending on what you need to do next

  9. 0

    rhalladay99

    Imported from the Apple Support Forums via the Wayback Machine 🔗

    I'm trying to get it to Run a total or Sum, of the hours and minutes and then the Dur2Hours. But if it skips a day, i.e. day off, it gives this Triangle.

  10. 0

    rhalladay99

    Imported from the Apple Support Forums via the Wayback Machine 🔗

    I deleted the formula from the cells

  11. 0

    Badunit

    Imported from the Apple Support Forums via the Wayback Machine 🔗

    Yo definitely need to be careful using date-time values. You might be better off formatting those columns as text so they are truly just the time of day, with no date attached.

  12. 0

    rhalladay99

    Imported from the Apple Support Forums via the Wayback Machine 🔗

    I changed the column from date to days of the week, and I think I got it!!

    Thanks EVERYONE!