Posted to microsoft.public.excel.worksheet.functions

Meebers

external usenet poster

Posts: 80

Time Calc 24 hrs

I am trying to figure out how I can subtract 2 times: day 1=7:20 am and day
2 = 14:45 answer should be 31:25. I need to use the result when averaging
the column. Formula used is : =IF(COUNT(N50,S50)=2,MOD(S50-N50,1),"")
giving me 7:35 which would be correct if within 24 hrs. TIA

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
Time Calc	Robert B.	Excel Worksheet Functions	5	November 7th 07 04:33 AM
calc time value	kevcar40	Excel Discussion (Misc queries)	3	November 1st 07 01:49 PM
Calc F9) Button and time.	Timmy Mac1	Excel Discussion (Misc queries)	3	November 9th 05 06:40 PM
time sheet calc by time in and out	JenMo	Excel Worksheet Functions	1	June 7th 05 06:23 PM
Problem with time calc	Tom	Excel Worksheet Functions	2	November 6th 04 12:04 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us