Time Format [H]:MM
Ahhhh now I get you! Thanks very much for your help
Angie
"Toppers" wrote:
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" wrote:
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
|