Time Format [H]:MM

G

Guest

I have used the format [H]:MM to add times together but in some cells the
date appears. For example 234:44 hours shows as 234:44 in the cell but in the
format line it is 09/01/1900 19:44:00

Can anyone tell me what I have done wrong please?

Thanks

Angie
 
G

Guest

Nothing is wrong!

The Formula Bar shows it as 9 days (9*24 =216) and the balance as
hours:minutes which should be 18:44:00.
 
G

Guest

Ahhhh now I get you! Thanks very much for your help

Angie

Toppers said:
Nothing is wrong!

The Formula Bar shows it as 9 days (9*24 =216) and the balance as
hours:minutes which should be 18:44:00.

Angiewelly said:
I have used the format [H]:MM to add times together but in some cells the
date appears. For example 234:44 hours shows as 234:44 in the cell but in the
format line it is 09/01/1900 19:44:00

Can anyone tell me what I have done wrong please?

Thanks

Angie
Click to expand...
Click to expand...
 

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

Converting dd:hh:mm to [h]:mm not working. 3
Formating time 2
Subtracting 37 hours from a cell containing format [h]:mm 2
Pivot table Average with [h]:mm format 5
limit on [h]:mm time format? 14
One more question re: pay calcs using [h]:mm format for time worke 4
Excel Convert Datetime Stamp to HH and MM Worked 7
Cell showing date and time - precision error 2

Top