LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 4
Default How to calculate hours based on certain criteria

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Calculate time worked based on start / end times & working hours MeatLightning Excel Discussion (Misc queries) 3 June 25th 09 04:25 PM
Calculate FREQUENCY based on criteria... MeatLightning Excel Discussion (Misc queries) 4 February 4th 09 01:06 AM
formula calculate charges based on hours Pammy Excel Discussion (Misc queries) 1 September 4th 07 07:54 PM
Calculate mode based on criteria goofy11 Excel Worksheet Functions 1 November 27th 06 09:55 PM
calculate the sum based on two different criteria Ken Excel Discussion (Misc queries) 1 May 22nd 05 09:58 AM


All times are GMT +1. The time now is 10:07 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"