Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hi,
I'm using a spreadsheet to keep track of my driving times, to make sure I get all the hours needed to get my license. All I have now is a column for START TIME, END TIME, NOTES, MINUTES, and TOTAL. I'm currently using the NOTES column to state whether or not the time is at night. The problem with that is I am not good at doing math with time, so I can't tell how many minutes of driving I have done at night. I'm simply wondering if there is a way to only add the times from the minutes column if either a) the NOTES column states that it was at night, or b) if the times are later than a specified time. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Calculate time worked based on start / end times & working hours | Excel Discussion (Misc queries) | |||
Calculate FREQUENCY based on criteria... | Excel Discussion (Misc queries) | |||
formula calculate charges based on hours | Excel Discussion (Misc queries) | |||
Calculate mode based on criteria | Excel Worksheet Functions | |||
calculate the sum based on two different criteria | Excel Discussion (Misc queries) |