| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
calculate time does not calculate
Hello
report comes from another system - which I import into excel 2002 -cells are formatted as general Here we go... row 1 has the headings , row 2 has the name of the employee. column D has the log in time , column E has the lunch log out time the row below has the same employee name again column d has the log in time after lunch, row e has the last log out time In this simple example the person worked 6:30 hours Name In 0ut Smith 8:00am 11:00am Smith 12:00PM 3:30PM what I need to know is the total hours worked during a day. I tried this formula =TEXT(H14-F14,"hh:mm") but I get and answer of #VALUE I tired formatting the cells as time - but it did not work. Thanks in advance |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
calculate time does not calculate
Hi, how about using a 24 hour system ,,, like 3pm becomes 1500 hrs?
Col A Col B Col C Col D Row1 Smith 0800 1100 =sum(C1-B1) Row2 Smith 1200 1500 =sum(C2-B2) Row3 Total Hrs Worked =sum(D1+D2) "Wanna Learn" wrote: Hello report comes from another system - which I import into excel 2002 -cells are formatted as general Here we go... row 1 has the headings , row 2 has the name of the employee. column D has the log in time , column E has the lunch log out time the row below has the same employee name again column d has the log in time after lunch, row e has the last log out time In this simple example the person worked 6:30 hours Name In 0ut Smith 8:00am 11:00am Smith 12:00PM 3:30PM what I need to know is the total hours worked during a day. I tried this formula =TEXT(H14-F14,"hh:mm") but I get and answer of #VALUE I tired formatting the cells as time - but it did not work. Thanks in advance |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
calculate time does not calculate
format the cells as [h]:mm
this should work :) "Wanna Learn" wrote in message ... Hello report comes from another system - which I import into excel 2002 -cells are formatted as general Here we go... row 1 has the headings , row 2 has the name of the employee. column D has the log in time , column E has the lunch log out time the row below has the same employee name again column d has the log in time after lunch, row e has the last log out time In this simple example the person worked 6:30 hours Name In 0ut Smith 8:00am 11:00am Smith 12:00PM 3:30PM what I need to know is the total hours worked during a day. I tried this formula =TEXT(H14-F14,"hh:mm") but I get and answer of #VALUE I tired formatting the cells as time - but it did not work. Thanks in advance |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
calculate time does not calculate
Excel wants a space before the AM or PM. Without the space, it sees it as
text instead of a time. -- David Biddulph "Wanna Learn" wrote in message ... Hello report comes from another system - which I import into excel 2002 -cells are formatted as general Here we go... row 1 has the headings , row 2 has the name of the employee. column D has the log in time , column E has the lunch log out time the row below has the same employee name again column d has the log in time after lunch, row e has the last log out time In this simple example the person worked 6:30 hours Name In 0ut Smith 8:00am 11:00am Smith 12:00PM 3:30PM what I need to know is the total hours worked during a day. I tried this formula =TEXT(H14-F14,"hh:mm") but I get and answer of #VALUE I tired formatting the cells as time - but it did not work. Thanks in advance |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
calculate time does not calculate
Why the SUM() function, John? What's wrong with =C1-B1, and so on?
-- David Biddulph "John Moore" wrote in message ... Hi, how about using a 24 hour system ,,, like 3pm becomes 1500 hrs? Col A Col B Col C Col D Row1 Smith 0800 1100 =sum(C1-B1) Row2 Smith 1200 1500 =sum(C2-B2) Row3 Total Hrs Worked =sum(D1+D2) "Wanna Learn" wrote: Hello report comes from another system - which I import into excel 2002 -cells are formatted as general Here we go... row 1 has the headings , row 2 has the name of the employee. column D has the log in time , column E has the lunch log out time the row below has the same employee name again column d has the log in time after lunch, row e has the last log out time In this simple example the person worked 6:30 hours Name In 0ut Smith 8:00am 11:00am Smith 12:00PM 3:30PM what I need to know is the total hours worked during a day. I tried this formula =TEXT(H14-F14,"hh:mm") but I get and answer of #VALUE I tired formatting the cells as time - but it did not work. Thanks in advance |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| calculate from time started and finished to get total time used | Excel Worksheet Functions | |||
| Calculate the duration between the end time and start time of anot | Excel Worksheet Functions | |||
| Calculate Ending time using Start Time and Elapsed Time | Excel Worksheet Functions | |||
| IF statement to calculate time usage in specific time bands | Excel Worksheet Functions | |||
| how to calculate time start & time finish in quarter hour | Excel Discussion (Misc queries) | |||
Linear Mode
