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.
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.
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.
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.
0
Wayne Contello·
Imported from the Apple Support Forums via the Wayback Machine 🔗
use the formula:
=DUR2HOURS(C2-B2)
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.
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.
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??
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
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.
0
rhalladay99·
Imported from the Apple Support Forums via the Wayback Machine 🔗
I deleted the formula from the cells
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.
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!!