Introducir horario en excel

Hola,
Necesito condicionar una celda de excel para que admita un horario tipo de 8 a 15 o de 8:00 a 15:00, de forma que me lo reconozca como tal para después poder calcular las horas realizadas, por ejemplo de 8 a 15 = 7 horas.
Un saludo.

1 respuesta

Respuesta
1
Si no entendí mal, quieres poner en una misma celda números y letras... (8 a 15), si es así, esa celda no la puedes usar para calcular ya que es una celda de "texto".
Lamentablemente tienes que usar dos celdas distintas, una para horario de "entrada" y optra para "salida".

Añade tu respuesta

Haz clic para o

Más respuestas relacionadas

Tips to start designing websites?

There is no a definitive process to follow step by step when it comes to designing a website, because in reality each designer has their own way of designing and routine to follow and it works. The truth is that there are many steps that you must...
14 respuestas

How can I improve my chances of winning in Megaways casino?

There is no sure-fire way to win in any slot game, but there are some tips that can help you improve your chances. In Megaways slots, the number of ways to win can vary from game to game, so it is important to choose a game with a high number of ways...
18 respuestas

Online Casinos Can Catch and Grab You for KeepsWhile many people enjoy the thrill of playing casino games .

Online Casinos Can Catch and Grab You for Keeps While many people enjoy the thrill of playing casino games from the comfort of their own homes, it is important to remember that online casinos can catch and grab you for keeps. This is because of the...
21 respuestas

Casino Montreal Joins Les Cuisines Solidaires Project

Loto-Quebec is once again proving it is ready to support the province in many ways than simply allocating casino cash on a regular basis. Casino Montreal is about to make the best of the situation and use its premium quality kitchen áreas for the...
1 respuesta

How to choose the best betting platform?

Hi! Who knows what rules I should follow when choosing an excellent betting site. Who knows where to look? I will be glad of good recommendations!
16 respuestas

¿Se pueden automatizar procesos en excel?

La presente es para solicitar amablemente su ayuda, como pueden observar en el presente archivo de excel denominado relación de consumos de QBANO, tengo 3 hojas con los siguientes nombres: HODECOL, MULTIVACIONES Y SERVINCLUIDOS, necesito una macro o...
1 respuesta

I need good Dating site, pls

Hello! Where can I find a site with real people for flirting and pleasant communication? I just want to get a good mood from communicating with cute attractive people.
10 respuestas

How Can You Have 2 Cash App Accounts Though A Personal Account Is Also Set Up?

For security reasons, Cash App doesn’t allow users to use a common bank account between your personal and business accounts. So, if you would like to do the same, the only condition is you must have two different mobile numbers, email address and...
10 respuestas

What are the benefits of home health care?

¿What are the benefits of home health care? All healthcare is potentially beneficial. But healthcare really needs to be viewed as a whole. There are times when home healthcare is suitable and others where it isn’t. It should be viewed as one of the...
23 respuestas

Instant Access to Payment Information

Through online platforms or mobile applications, beneficiaries can quickly determine whether their payments have been processed for get more idea, the amount they are due to receive, and the expected date of payment. This level of transparency is...
2 respuestas