Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
working out a sum in time?
Can anyone help??
I am in the process of building a spreadsheet, and in part of it I need to determine whether or not a field for time taken, displayed as a time is or < a goal time (4hrs), and by how much. column A = start time column B = finish time column c = overall time taken column d = difference of overall time taken to 4hrs any advice very much appreciated -- Tim |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
working out a sum in time?
Format column A and B cells to "time" in numbers tab (i.e. 1:30PM).
C1 formula should be: =(B1-A1)*24 D1 formula should be C1-4. "Tim" wrote: Can anyone help?? I am in the process of building a spreadsheet, and in part of it I need to determine whether or not a field for time taken, displayed as a time is or < a goal time (4hrs), and by how much. column A = start time column B = finish time column c = overall time taken column d = difference of overall time taken to 4hrs any advice very much appreciated -- Tim |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
working out a sum in time?
Caroline,
Thanks, but I did all that and just got ############ in column D. I have tweaked it and now i am trying to get colmun D to say either YES or NO to the 4hr argument, but having no look there also. I can get it to work if total time taken is less than 4hrs, but not if it is over. Any ideas? Please help! -- Tim "Caroline" wrote: Format column A and B cells to "time" in numbers tab (i.e. 1:30PM). C1 formula should be: =(B1-A1)*24 D1 formula should be C1-4. "Tim" wrote: Can anyone help?? I am in the process of building a spreadsheet, and in part of it I need to determine whether or not a field for time taken, displayed as a time is or < a goal time (4hrs), and by how much. column A = start time column B = finish time column c = overall time taken column d = difference of overall time taken to 4hrs any advice very much appreciated -- Tim |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
working out a sum in time?
Try formatting it as General.
Tim wrote: Caroline, Thanks, but I did all that and just got ############ in column D. I have tweaked it and now i am trying to get colmun D to say either YES or NO to the 4hr argument, but having no look there also. I can get it to work if total time taken is less than 4hrs, but not if it is over. Any ideas? Please help! -- Tim "Caroline" wrote: Format column A and B cells to "time" in numbers tab (i.e. 1:30PM). C1 formula should be: =(B1-A1)*24 D1 formula should be C1-4. "Tim" wrote: Can anyone help?? I am in the process of building a spreadsheet, and in part of it I need to determine whether or not a field for time taken, displayed as a time is or < a goal time (4hrs), and by how much. column A = start time column B = finish time column c = overall time taken column d = difference of overall time taken to 4hrs any advice very much appreciated -- Tim -- Dave Peterson |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
working out a sum in time?
inD1:
=IF(C14,"YES","NO") "Dave Peterson" wrote: Try formatting it as General. Tim wrote: Caroline, Thanks, but I did all that and just got ############ in column D. I have tweaked it and now i am trying to get colmun D to say either YES or NO to the 4hr argument, but having no look there also. I can get it to work if total time taken is less than 4hrs, but not if it is over. Any ideas? Please help! -- Tim "Caroline" wrote: Format column A and B cells to "time" in numbers tab (i.e. 1:30PM). C1 formula should be: =(B1-A1)*24 D1 formula should be C1-4. "Tim" wrote: Can anyone help?? I am in the process of building a spreadsheet, and in part of it I need to determine whether or not a field for time taken, displayed as a time is or < a goal time (4hrs), and by how much. column A = start time column B = finish time column c = overall time taken column d = difference of overall time taken to 4hrs any advice very much appreciated -- Tim -- Dave Peterson |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
working out a sum in time?
Thank you all very much, it looks fine now :)
-- Tim "Toppers" wrote: inD1: =IF(C14,"YES","NO") "Dave Peterson" wrote: Try formatting it as General. Tim wrote: Caroline, Thanks, but I did all that and just got ############ in column D. I have tweaked it and now i am trying to get colmun D to say either YES or NO to the 4hr argument, but having no look there also. I can get it to work if total time taken is less than 4hrs, but not if it is over. Any ideas? Please help! -- Tim "Caroline" wrote: Format column A and B cells to "time" in numbers tab (i.e. 1:30PM). C1 formula should be: =(B1-A1)*24 D1 formula should be C1-4. "Tim" wrote: Can anyone help?? I am in the process of building a spreadsheet, and in part of it I need to determine whether or not a field for time taken, displayed as a time is or < a goal time (4hrs), and by how much. column A = start time column B = finish time column c = overall time taken column d = difference of overall time taken to 4hrs any advice very much appreciated -- Tim -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Working with Time | Excel Worksheet Functions | |||
SUMProduct working most of the time... | Excel Discussion (Misc queries) | |||
working with time in minus | Excel Worksheet Functions | |||
Working with If statements and time | Excel Worksheet Functions | |||
EU Working Time Directive | Excel Discussion (Misc queries) |