Posted to microsoft.public.excel.misc

RKS

external usenet poster

Posts: 63

time calculation

Sir,

Pl help me calculate the hours. I have two col A & B
A B C
Time In Time Out Working Days

17:00 ( 5pm) 02:00 a.m. (Next Days) = 9 hours
17:00 15:00 p.m. (next days) = 22 hpurs

how i can apply formula.

RKS

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 calculation (Subraction of Idle Time)	Ajay	Excel Discussion (Misc queries)	6	March 4th 07 11:54 AM
TIME CALCULATION	Rick	Excel Discussion (Misc queries)	7	October 12th 06 05:33 PM
Time Calculation	Gary	Excel Worksheet Functions	3	September 14th 06 06:45 PM
Ignoring Time in a Date Time Calculation	nmp	Excel Worksheet Functions	3	November 23rd 05 08:32 PM
time calculation with military time	Ron Thetford	Excel Worksheet Functions	8	July 29th 05 07:24 PM

All times are GMT +1. The time now is 11:59 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us