TRANSFORM THE HOURS INTO NUMBER

MarioLamera wrote:

I turn hours into numbers

You can use the DUR2HOURS function:

English:

=DUR2HOURS(D2)

Italian:

=DUR.ORE(D2)

Also, have a look at the 'Employee Schedule' template at File > New in your menu.

SG

If is is a duration of 10hrs 50min in a cell formatted as duration or is the result of a formula that creates a duration, use the DUR2HOURS function to turn it into a decimal number of hours.

If it is 10:50 in a cell formatted as text, the duration functions will interpret it as 10 min 50 sec. You can use the DUR2MINUTES function and pretend the result is decimal hours.

It would help us read your posts if you didn't put them within the < > code insertion block.

What do you mean by :

"if there are more names and more days (month) what can I do?"

Have you had a look at the Numbers User Guide at Help > Numbers Help in your menu?

As your topic seems to be shifting from your original post perhaps you could start a new thread with specifics (including screenshot) of what you are trying to do. To post a screenshot: shift-command-4, drag the "cross-hairs" to select the area on the screen, release, start new post and use the "mountain and moons" icon to insert the screenshot image from the Desktop.

SG

are these durations or times?

It's under the business section in the template chooser:

It's not possible to color the "tab" of a sheet.

SG

not sure what you are asking here... are you asking to extract the hour portion of a time formatted cell?

if so, you can use the hour function for that

=HOUR(A2)

Jason