Adding hours and minutes

P

Phippsy

Hi

When adding for example overtime I format the cells to be [h]:mm and this
will add beyond 24 hours. However for any value over 24 hours the formula bar
displays a date even though the totals add up with the correct result. How do
I change this to show in date format.
 
L

Luke M

You can't change what the formula bar says. But, its really just a different
way of looking at data. 70 minutes = 1 hr, 10 min = 1:10 AM = 1/0/1900 1:10
AM

If the formula bar displaying a date really bothers you, you can hide it via
Tools-Options-View.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Adding Hours 1
How do I get total amount of hours in time format 3
Adding hours 6
Adding hours and minutes 7
Adding up hours and minutes 18
Calculating number of hours and minutes 6
Split hours and minutes in two different cells 4
Adding hours and minutes 2

Top