time sheet problem

  ca 21:15 31 May 03
Locked

Can anyone help me i am using Excel XP pro and my problem is that i have link 4 worksheet together (my Time sheet for a month) every thing works until i try to add all the weeks together. I formatted the cell to hh:mm:ss but instead of giving me 157.30 hrs it gave me 2:37:30 please tell me what i am doing wrong

  jazzypop 21:20 31 May 03

Trt to format the result cell to hh:mm

It looks as if it has divided 157:30 by 60 (minutes) to give 2 hours, 37 min and 30 sec

  ca 21:25 31 May 03

did try this nothing happened just the same tried hh:mm:ss, hh:mm,

  Roland Butter 21:30 31 May 03

I might be asking the obvious, but are you typing : between the hours and mins?

  ca 21:33 31 May 03

yes

  jazzypop 22:39 31 May 03

1. Are all the 'feeder' cells formatted the same? (the cells that provide the daily/weekly subtotals)

2. Is the final total cell formatted the same as the feeder cells?

  ca 23:59 31 May 03

Thanks every one have now worked out it was down to the way i was inputting the information many thanks

This thread is now locked and can not be replied to.

How to get Windows 10 for free | How to install Windows 10: There is still a way to avoid paying…

1995-2015: How technology has changed the world in 20 years

Alex Chinneck’s giant ice cube Christmas tree at Kings Cross

Apple rumours & predictions 2017: The iPhone 8, new iPads, and everything else you should expect fr7…