Posted to microsoft.public.excel.worksheet.functions

Dukey

external usenet poster

Posts: 2

Calculating Military Time

I need a formula so when I type in 2:00 PM it gives me 14:00. Or when I
type in 7:00 PM it gives me 19:00. Also need a formula to add the military
time. For example: If I come to work at 08:00 AM and leave at 5:00PM
(17:00 PM) it will give me the amount of hours worked.

Thanks Dukey

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
Converting Standard Time to Military Time in Excel	mtvschultz	Excel Discussion (Misc queries)	3	May 5th 23 11:42 AM
formula for converting military time to standard time, etc	Pattio	Excel Discussion (Misc queries)	8	February 17th 08 01:12 AM
Converting Standard Time into Military Time	mtvschultz	Excel Discussion (Misc queries)	3	February 15th 08 07:34 PM
Show timesheet time in and out in regular time versus military tim	John	Excel Worksheet Functions	1	November 11th 05 05:14 AM
Military Time	Sue	Excel Worksheet Functions	2	May 2nd 05 05:45 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us