calculating hours on excel

• skeujin

  16 Jun 06, 20:55

  hi guys need help. payroll time of the month.
  
  e.g.
  
  clock in time in column A is 17:00
  
  clock out time in column B is 03:00
  
  wat formula can i use to get the number of hours worked as 10...?
  
  
• ^spidee^

  16 Jun 06, 21:01

  as in 10am?
• skeujin

  17 Jun 06, 02:04

  not 10 am
  
  i wana formula thn can calculate hour many hours worked
• ndmmxiaomayi

  17 Jun 06, 13:17

  Format the cells that has the time. Change all to 24-hr format.
  
  
  
  Input the date first, followed by the time. For time, make sure it's separated by colon ( : ). For example, do not input 1700, but 17:00. Then subtract accordingly. The results will be weird, especially the date, just look at the time. Change the am or pm into hours. It's correct.