Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Adding time
Thanks to a lot of people I have nearly got my work duty sheets up and
running.......but i've hit a snag..... I have everyones start and finish time........finish time - start time = hours worked....... MONDAY 08:15 17:35 09:20 TUESDAY 08:20 17:45 09:25 WEDNESDAY 08:45 17:35 08:50 THURSDAY 08:50 17:35 08:45 FRIDAY 08:50 12:30 03:40 SATURDAY OFF TOTAL HOURS 16:00 I'm trying to get the right hand column to add up the hours worked which should add to 40 hours (so long as i havent made a mistake...) BUT.....it's not doing it correctly..... I have all columns formatted as Custom......HH:MM I thought it would be easy to add the right hand column up.....but to me it's proving a bit of a hurdle... Can you help me...Thanks in Advance... Dave :)))) |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Adding time
Sussed it ...Via Google.............
"DB" wrote in message . uk... Thanks to a lot of people I have nearly got my work duty sheets up and running.......but i've hit a snag..... I have everyones start and finish time........finish time - start time = hours worked....... MONDAY 08:15 17:35 09:20 TUESDAY 08:20 17:45 09:25 WEDNESDAY 08:45 17:35 08:50 THURSDAY 08:50 17:35 08:45 FRIDAY 08:50 12:30 03:40 SATURDAY OFF TOTAL HOURS 16:00 I'm trying to get the right hand column to add up the hours worked which should add to 40 hours (so long as i havent made a mistake...) BUT.....it's not doing it correctly..... I have all columns formatted as Custom......HH:MM I thought it would be easy to add the right hand column up.....but to me it's proving a bit of a hurdle... Can you help me...Thanks in Advance... Dave :)))) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
adding time | Excel Discussion (Misc queries) | |||
Adding time | Excel Worksheet Functions | |||
Adding time AM/PM | Excel Discussion (Misc queries) | |||
Time log adding time from separate sheets | New Users to Excel | |||
Adding time to date-time formatted cell | Excel Discussion (Misc queries) |